This function, Is Number Odd, tests whether a value, an expression, or contents of a referenced cell has numeric data.
Syntax
ISODD(cellreference)
ISODD(value)
ISODD(expression)
Arguments
Specify a cell reference, a numeric or text value, or an expression for the argument.
Remarks
Use this function to test the contents of a cell, a numeric or text value directly, or a function or expression.
If the number specified by the argument is odd, the function returns TRUE. If the number specified by the argument is even, the function returns FALSE. If the number specified by the argument is zero, the function returns FALSE. If the number specified by the argument refers to an empty cell or to no data, the function returns TRUE.
Data Types
Accepts any data type for an argument. Returns Boolean (TRUE or FALSE) data.
Examples
ISODD(B3)
ISODD(R1C2)
ISODD(12) gives the result FALSE
ISODD(2.5) gives the result FALSE
ISODD(3.6) gives the result TRUE
ISODD(ROUND(3.6)) gives the result FALSE
Version Available
This function is available in product version 1.0 or later.
See Also
ISEVEN | ODD | Information Functions