Difference between revisions of "Manuals/calci/ISLEAPYEAR"

(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="...")
 
 
(7 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left"> 
+
<div style="font-size:30px">'''ISLEAPYEAR(Year)'''</div><br/>
 +
*<math>Year</math> is the year to find whether it is leap year or not.
 +
**ISLEAPYEAR(),returns TRUE if the value is leap year.
  
<br />
+
==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.
  
<font face="Arial, sans-serif"><font size="2">'''ISLEAPYEAR(Y)'''</font></font>
+
==ZOS==
 +
*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)
  
<br />
+
==Examples==
 +
#=ISLEAPYEAR(2000) = TRUE
 +
#=ISLEAPYEAR(1998) = FALSE
 +
#=ISLEAPYEAR(3004) = TRUE
 +
#=ISLEAPYEAR() = FALSE
  
<font face="Arial, sans-serif">Where 'Y' is the year.</font>
+
==Related Videos==
  
</div>
+
{{#ev:youtube|iPtWI0qJn_U|280|center|LEAP YEAR}}
----
 
<div id="1SpaceContent" class="zcontent" align="left"> 
 
  
<font face="Arial, sans-serif">This function shows 1 if the year is a leap year.</font>
+
==See Also==
 +
*[[Manuals/calci/ISNUMBER  | ISNUMBER ]]
 +
*[[Manuals/calci/ISODD  | ISODD ]]
 +
*[[Manuals/calci/ISEVEN  | ISEVEN ]]
  
</div>
+
==References==
----
+
[http://en.wikipedia.org/wiki/Is_functions Is functions]
<div id="7SpaceContent" class="zcontent" align="left"> 
 
  
<font face="Arial, sans-serif">Here the function shows '1' if the year is a leap year. Otherwise it shows '0'</font>
 
  
</div>
 
----
 
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
ISLEAPYEAR
 
  
</div></div>
+
*[[Z_API_Functions | List of Main Z Functions]]
----
 
<div id="8SpaceContent" class="zcontent" align="left"> 
 
  
<br />
+
*[[ Z3 |  Z3 home ]]
 
 
<font face="Arial, sans-serif">Lets see an example,</font>
 
 
 
<br />
 
 
 
<font face="Arial, sans-serif"><nowiki>=ISLEAPYEAR(1996) is 1</nowiki></font>
 
 
 
<br />
 
 
 
<font face="Arial, sans-serif"><nowiki>=ISLEAPYEAR(1998) is 0</nowiki></font>
 
 
 
</div>
 
----
 
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
----
 
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
----
 
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
----
 
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
----
 
<div id="2SpaceContent" class="zcontent" align="left">
 
 
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
| class=" " |
 
| Column1
 
| class="  " | Column2
 
| Column3
 
| Column4
 
|- class="odd"
 
| class=" " | Row1
 
| class="sshl_f" | 1
 
| class="                                                                sshl_f " |
 
| class=" " |
 
| class="                                                            sshl_f  " |
 
|- class="even"
 
| class="  " | Row2
 
| class="sshl_f" | 0
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
|- class="odd"
 
| Row3
 
| class="                                      sshl_f  " |
 
| class="    " |
 
| class=" " |
 
| class=" " |
 
|- class="even"
 
| Row4
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
| class="  SelectTD  SelectTD" |
 
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
|- class="odd"
 
| class=" " | Row5
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
|- class="even"
 
| Row6
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
|}
 
 
 
<div align="left">[[Image:calci1.gif]]</div></div>
 
----
 

Latest revision as of 15:44, 2 July 2018

ISLEAPYEAR(Year)


  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Year} is the year to find whether it is leap year or not.
    • ISLEAPYEAR(),returns TRUE if the value is leap year.

Description

  • This function is one of the group in Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ISFUNCTIONS} .
  • The Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle IS FUNCTION} is also known as data information functions, data inspection functions or data-testing functions.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ISLEAPYEAR} 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ISLEAPYEAR(Year)} .
    • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Year} 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

Related Videos

LEAP YEAR

See Also

References

Is functions