The ISODD function evaluates a value and returns the logical value True if it is odd or the logical value False otherwise.
Syntax
ISODD(
number
)
Parameters
- number: Value to evaluate.
Returned value
The ISODD function returns a Boolean.
Additional Information
If the number to be evaluated is not an integer, ISODD rounds it to the nearest integer. Thus, ISODD(1.2) is equivalent to ISODD(1), and ISODD(1.9) is equivalent to ISODD(2).
If the value is not a number, ISODD returns the #VALUE! error.
Examples
In this example, the ISODD function is applied to different numbers (whole, fractional, positive, and negative). Notice how the function rounds non-integer numbers to the nearest integer:
Related functions
Category
Information
