Syntax
ISODD(number)
| Parameter | Description |
|---|---|
| number | Parameter of the ISODD function. |
Examples
Check odd number
Formula
=ISODD(7)
Returns TRUE because 7 is not divisible by 2.
Alternate processing
Formula
=IF(ISODD(ROW()), "Group A", "Group B")
Assigns odd rows to Group A and even rows to Group B. Simple way to split data into two alternating groups.
Validate serial numbers
Formula
=ISODD(RIGHT(A1,1)*1)
Checks if the last digit of a serial number is odd. RIGHT extracts the last character, *1 converts to number, ISODD checks parity.
Common Errors
#VALUE!
Occurs when the argument is non-numeric text. Numeric text strings may be auto-converted depending on the application.
Tips
Complement of ISEVEN
ISODD(x) always equals NOT(ISEVEN(x)). Use whichever makes your formula more readable.
Negative numbers work
ISODD(-3) returns TRUE. The function works correctly with negative integers.
Decimals are truncated
ISODD(4.7) returns FALSE because 4.7 truncates to 4, which is even.
Try ISODD in Viztab
Import your data and use ISODD with 370+ other formulas. No signup required.
Open Viztab