Difference between revisions of "Manuals/calci/ISLEAPYEAR"

From ZCubes Wiki
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 Section==
+
==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

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

See Also

References

Is functions