Excel ISODD Function — How to Use It (with 3 Examples)

Contents

What does ISODD do?

ISODD returns TRUE if a number is odd, and FALSE if it is even. Like ISEVEN, decimal numbers are truncated to a whole number before the check.

It is functionally the exact opposite of ISEVEN for any given whole number.

=ISODD(number)

Argument	Description
number required	The number to test. Decimals are truncated first.

Example 1

Test an odd number

=ISODD(7)

Returns TRUE.

Example 2

Test an even number

=ISODD(4)

Returns FALSE.

Example 3

Highlight odd-numbered invoice IDs

=IF(ISODD(A2),"Flag","OK")

Useful in any scheme where odd-numbered items need separate handling, like alternating batches.

⚠️ Assuming ISODD and NOT(ISEVEN()) always agree

For any real number they do agree exactly — the two are mathematically equivalent ways of asking the same question.

Can I use MOD instead of ISODD?

Yes — =MOD(A2,2)=1 achieves the same result, and some people prefer it since MOD is more broadly familiar.

ExcelPro has 700+ hands-on Excel exercises across 7 career tracks — free to start, no download needed.

ISEVEN MOD SIGN