Excel like a finance pro.
← The libraryPractice · 2 questions →
Math function
ODD
Rounds a number up to the nearest odd integer.
Rarely usedDifficulty 1050 · CapableUsage rank #246 of 520
When to use it
Rounds away from zero to the nearest odd integer.
The shape of it
- Syntax
=ODD(number)
Worked examples
Even input
=ODD(2) → 3
Up to the next odd.
Fractional input
=ODD(3.1) → 5
3.1 is past 3, so the next odd is 5.
Negative input
=ODD(-2) → -3
Away from zero.
Worth knowing
- Symmetric layouts (a centre column plus equal sides) need odd counts.
- ISODD is the test; ODD is the rounding.
- ODD(0) is 1.
Where it goes wrong
- ODD(3.0001) is 5, which surprises people expecting 3.
- Always away from zero.
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.