ISODD Function
Checks whether a number is odd.
Category
Information
Available in
All versions, Microsoft 365
Returns
TRUE or FALSE
Want to practice ISODD in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
ISODD returns TRUE for odd numbers and FALSE for even ones. Like ISEVEN, it drops decimals first, so 3.5 counts as 3.
Negative numbers work the same way: -3 is odd.
Syntax
=ISODD(number) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The number to test. Decimals are truncated; text that isn't a number gives #VALUE!. |
Examples
Example 1 — Odd or even?
The decimal part is ignored.
B2fx=ISODD(A2)
| A | B | |
|---|---|---|
| 1 | Number | Odd? |
| 2 | 9 | TRUE |
| 3 | 12 | FALSE |
| 4 | 3.5 | TRUE |
| 5 | -3 | TRUE |
=ISODD(A2) Explain
Example 2 — Odd- and even-numbered aisles
Northstar's warehouse puts odd aisles on the east side.
B2fx=IF(ISODD(A2),"East","West")
| A | B | |
|---|---|---|
| 1 | Aisle | Side |
| 2 | 11 | East |
| 3 | 12 | West |
| 4 | 15 | East |
=IF(ISODD(A2),"East","West") Explain
Common mistakes
- A blank cell returns FALSE. Blank counts as 0, which is even. Guard with ISBLANK if that matters.
Notes
- =MOD(A2,2)=1 is the classic alternative, but it gives FALSE for decimals like 3.5, where ISODD says TRUE.
- Related functions: ISEVEN, MOD.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.