The ISODD function checks if the value is an odd number.
Returns TRUE if it is and FALSE if not.
This can be useful when you need to analyze data and select only even values.
Syntax
ISODD(value)
Argument |
Description |
Permitted values |
|---|---|---|
value |
Number that is checked whether it belongs to odd numbers |
Any number. Can be specified as a number, formula, function, or cell reference |
Examples of use
Checking whether the number 7 is odd:
=ISODD(7)
Result: TRUE.
Checking whether the number 10 is odd:
=ISODD(10)
Result: FALSE.
Checking whether the number in cell A1 is odd:
=ISODD(A1)
Result: TRUE or FALSE depending on the value in cell A1.
Notes
–If the argument is not a numerical value, the function will return the #VALUE! error.
–If the number is not an integer, it is rounded to the nearest integer before being checked.
–For negative numbers, parity or oddness is also determined.
–To check for parity, use the ISEVEN function.