writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + − + + + + + + + − <font face="Arial, sans-serif"><font size="2">'''ISLEAPYEAR(Y)'''</font></font>+ + + + + − <br />+ + + + − <font face="Arial, sans-serif">Where 'Y' is the year.</font>+ − − </div> − ---- − <div id="1SpaceContent" class="zcontent" align="left"> − − <font face="Arial, sans-serif">This function shows 1 if the year is a leap year.</font> − − </div> − ---- − <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> − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − − <br /> − − <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> − ----
Manuals/calci/ISLEAPYEAR (view source)
Revision as of 09:53, 20 December 2013
, 09:53, 20 December 2013no edit summary
<div id="6SpaceContent" class="zcontent" align="left">
<div style="font-size:30px">'''ISLEAPYEAR(n)'''</div><br/>
*<math>n</math> is the 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.
==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==