Administrators, writer
3,314
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + + + + + + + + + + + + + + + + + + + + + − Syntax+ − + − </div></div> − ---- − <div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify"> − − Examples − − </div></div> − ---- − <div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div> − ---- − <div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify"> − − <font size="5">Description</font> − − </div></div> − ---- − <div id="5SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">This function displays 1 if number is odd, or 0 if number is even.</font></font></font> − − </div></div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="6">ISODD</font></div></div> − ---- − <div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">Let's see an example</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=ISODD(9) is 1</nowiki></font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=ISODD(12) is 0</nowiki></font></font></font> − − </div></div> − ---- − <div id="6SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ISODD'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">N</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">where N''' '''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">is the value to test. </font></font></font> − − </div></div> − ---- − <div id="1SpaceContent" class="zcontent" align="left"> − − {| id="TABLE3" class="SpreadSheet blue" − |- class="even" − | class=" " | − | Column1 − | Column2 − | Column3 − | Column4 − |- class="odd" − | class=" " | Row1 − | class="sshl_f" | 9 − | class="sshl_f" | 1 − | − | − |- class="even" − | class=" " | Row2 − | class="sshl_f" | 12 − | class="sshl_f" | 0 − | − | − |- class="odd" − | Row3 − | class=" " | − | class="sshl_f SelectTD SelectTD" | − <div id="1Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="1Space_Copy" title="Click and Drag over to AutoFill other cells."></div> − | class="sshl_f" | − | class="sshl_f" | − |- class="even" − | Row4 − | − | − | − | − |- class="odd" − | class=" " | Row5 − | − | − | − | − |- class="even" − | Row6 − | − | − | − | − |} − − <div align="left">[[Image:calci1.gif]]</div></div> − ----
no edit summary
<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
<div style="font-size:30px">'''ISODD(n)'''</div><br/>
*<math>n</math> is the value to test.
==Description==
*This function is one of the group in ISFUNCTIONS.
*The IS FUNCTION is also known as data inform ation functions, data inspection functions or data-testing functions.
*ISODD function can be used to check the given value is odd or not.
*This function gives the result as only TRUE or FALSE.
*The result is TRUE when the n value is odd otherwise the result is FALSE..
*The argument can be blank, or it can contain data such as text, numbers, error values, logical values or any equations.
*This function will not convert any numbers from the text.
*For e.g. "11" is normally converted as a number 11.
*But in ISODD("11") will return NAN, because "11" will not convert in to number.
==Examples==
#ISODD(5)=TRUE
#ISODD(0)=TRUE
#ISODD(100)=FALSE
#ISODD(5*3)=TRUE
#ISODD(500/10.5)=TRUE
#ISODD(5624.76-2654.42)=FALSE
#ISODD(265+452)=TRUE
#ISODD(-465)=TRUE
==See Also==
*[[Manuals/calci/ISEVEN | ISEVEN ]]
*[[Manuals/calci/ISNUMBER | ISNUMBER ]]
==References==
[http://en.wikipedia.org/wiki/Pearson_product-moment_correlation_coefficient Correlation]