ISODD function
ISODD returns TRUE if a number is odd and FALSE if it is even. Decimals are truncated before the test, so 3.9 is treated as 3 and counts as odd.
Example
Read it as a sentence: check whether the value in F1 is an odd number, which gives FALSE.
Excel shows FALSE
F
1
Data
Syntax
ISODD(number)
-
number(required) - The number to test.
Returns: TRUE for an odd number.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ISODD(3) | TRUE | Odd |
=ISODD(2) | FALSE | Even |
=ISODD(3.9) | TRUE | Fractional |
=ISODD(-3) | TRUE | Negative |
=ISODD("5") | TRUE | Text number |
=ISODD(Data!F1) | FALSE | Blank |
=ISODD("a") | #VALUE! | Text |
=ISODD(TRUE) | #VALUE! | Bool |
The Data sheet these formulas read
A cell that starts with = holds that formula.
F
1
Data
Watch out for
- Decimals are truncated first.
Where it works
- Excel
- ISODD is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Information functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .