Difference between revisions of "Manuals/calci/ISODD"
Jump to navigation
Jump to search
| Line 3: | Line 3: | ||
==Description== | ==Description== | ||
*This function is one of the group in ISFUNCTIONS. | *This function is one of the group in ISFUNCTIONS. | ||
| − | *The IS FUNCTION is also known as | + | *The IS FUNCTION is also known as Data Information Functions, Data Inspection Functions or Data-testing Functions. |
*ISODD function can be used to check the given value is odd or not. | *ISODD function can be used to check the given value is odd or not. | ||
*This function gives the result as only TRUE or FALSE. | *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 result is TRUE when the <math>n</math> value is odd otherwise the result is FALSE.. |
| − | *The argument can be blank, or it can contain data such as text, numbers, error values, | + | *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. | *This function will not convert any numbers from the text. | ||
*For e.g. "11" is normally converted as a number 11. | *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. | *But in ISODD("11") will return NAN, because "11" will not convert in to number. | ||
| + | |||
==Examples== | ==Examples== | ||
#ISODD(5)=TRUE | #ISODD(5)=TRUE | ||
Revision as of 03:37, 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 Information 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 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