Difference between revisions of "Manuals/calci/ISLEAPYEAR"
Jump to navigation
Jump to search
Line 10: | Line 10: | ||
*For the ISFUNCTION the argument can be blank, or it can contain data such as text, numbers, error values, or logical values. | *For the ISFUNCTION the argument can be blank, or it can contain data such as text, numbers, error values, or logical values. | ||
− | ==ZOS | + | ==ZOS== |
*The syntax is to find whether the given year is leap or not in ZOS is <math>ISLEAPYEAR(year)</math>. | *The syntax is to find whether the given year is leap or not in ZOS is <math>ISLEAPYEAR(year)</math>. | ||
**<math>year</math> is the year to find whether it is leap year or not. | **<math>year</math> is the year to find whether it is leap year or not. |
Revision as of 12:30, 3 June 2015
ISLEAPYEAR(year)
- is the year to find whether it is leap year or not.
Description
- This function is one of the group in .
- The is also known as data information functions, data inspection functions or data-testing functions.
- function is used to find the year is leap year or not.
- The function is giving the result as TRUE when the given year is leap year otherwise this function will return as FALSE.
- When we omitting the year value then the function will return the result as FALSE.
- For the ISFUNCTION the argument can be blank, or it can contain data such as text, numbers, error values, or logical values.
ZOS
- The syntax is to find whether the given year is leap or not in ZOS is .
- is the year to find whether it is leap year or not.
- For e.g.,ISLEAPYEAR(2003..2008)
Examples
- =ISLEAPYEAR(2000) = TRUE
- =ISLEAPYEAR(1998) = FALSE
- =ISLEAPYEAR(3004) = TRUE
- =ISLEAPYEAR() = FALSE