Excel like a finance pro.
← The libraryPractice · 2 questions →
Information function
ISODD
Returns TRUE if a number is odd.
OccasionalDifficulty 950 · CapableUsage rank #175 of 520
When to use it
TRUE for odd integers.
The shape of it
- Syntax
=ISODD(number)
Worked examples
Odd
=ISODD(3) → TRUE
Odd.
Even
=ISODD(4) → FALSE
Even.
Negative
=ISODD(-3) → TRUE
Negatives work.
Worth knowing
- MOD(x,2)=1 is the same test for positives.
- Alternate-row logic: ISODD(ROW()).
- Zero is not odd.
Where it goes wrong
- Text returns #VALUE!.
- Decimals are truncated first.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.