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

ArgumentRequired?What it does
numberYesThe 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)
AB
1NumberOdd?
29TRUE
312FALSE
43.5TRUE
5-3TRUE
=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")
AB
1AisleSide
211East
312West
415East
=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.
Kyle Stott

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.