Difference between revisions of "Manuals/calci/ISLEAPYEAR"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | <div style="font-size:30px">'''ISLEAPYEAR( | + | <div style="font-size:30px">'''ISLEAPYEAR(year)'''</div><br/> |
− | *<math> | + | *<math>year</math> is the year to find whether it is leap year or not. |
==Description== | ==Description== | ||
Line 9: | Line 9: | ||
*When we omitting the year value then the function will return the result 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. | *For the ISFUNCTION the argument can be blank, or it can contain data such as text, numbers, error values, or logical values. | ||
+ | |||
+ | ==ZOS Section== | ||
+ | *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. | ||
+ | *For e.g.,ISLEAPYEAR(2003..2008) | ||
==Examples== | ==Examples== |
Revision as of 03:05, 3 July 2014
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 Section
- 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