Difference between revisions of "Manuals/calci/ISLEAPYEAR"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <br /> <font face="Arial, sans-serif"><font size="2">'''ISLEAPYEAR(Y)'''</font></font> <br /> <font face="...") |
|||
Line 1: | Line 1: | ||
− | <div | + | <div style="font-size:30px">'''ISLEAPYEAR(n)'''</div><br/> |
+ | *<math>n</math> is the year. | ||
− | < | + | ==Description== |
+ | *This function is one of the group in <math>ISFUNCTIONS</math>. | ||
+ | *The <math>IS FUNCTION</math> is also known as data information functions, data inspection functions or data-testing functions. | ||
+ | *<math>ISLEAPYEAR</math> 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. | ||
− | + | ==Examples== | |
+ | #ISLEAPYEAR(2000)=TRUE | ||
+ | #ISLEAPYEAR(1998)=FALSE | ||
+ | #ISLEAPYEAR(3004)=TRUE | ||
+ | #ISLEAPYEAR()=FALSE | ||
− | + | ==See Also== | |
+ | *[[Manuals/calci/ISNUMBER | ISNUMBER ]] | ||
+ | *[[Manuals/calci/ISODD | ISODD ]] | ||
+ | *[[Manuals/calci/ISEVEN | ISEVEN ]] | ||
− | + | ==References== | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
Revision as of 03:53, 20 December 2013
ISLEAPYEAR(n)
- is the year.
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.
Examples
- ISLEAPYEAR(2000)=TRUE
- ISLEAPYEAR(1998)=FALSE
- ISLEAPYEAR(3004)=TRUE
- ISLEAPYEAR()=FALSE