Difference between revisions of "Manuals/calci/ISODD"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <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] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 01:31, 12 December 2013
ISODD(n)
- is the value to test.
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