Difference between revisions of "Manuals/calci/ISLEAPYEAR"

From ZCubes Wiki
Jump to navigation Jump to search
Line 1: Line 1:
<div style="font-size:30px">'''ISLEAPYEAR(n)'''</div><br/>
+
<div style="font-size:30px">'''ISLEAPYEAR(year)'''</div><br/>
*<math>n</math> is the year.  
+
*<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 04: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

  1. =ISLEAPYEAR(2000) = TRUE
  2. =ISLEAPYEAR(1998) = FALSE
  3. =ISLEAPYEAR(3004) = TRUE
  4. =ISLEAPYEAR() = FALSE

See Also

References

Is functions