ODD
Rounds a number up to the nearest odd integer (away from zero).
ODD(number)Arguments
numberThe number to round to the next odd integer.
=ODD(2)Rounds 2 up to the next odd integer
=ODD(1.5)Rounds 1.5 up to the next odd integer
=ODD(-2)Negatives are rounded away from zero
- •Always rounds away from zero
- •Returns 1 if number is 0
- •Use EVEN() to round to the nearest even integer instead
- •Assuming ODD rounds to the nearest odd number - it actually always rounds away from zero to the next odd number, regardless of which odd number is closer
- •Applying ODD to a number that's already odd, expecting it to stay the same - it does stay the same in that case, but the away-from-zero rounding rule can still surprise people who don't realize ODD never rounds down for positive numbers
- •Confusing ODD with EVEN - ODD always rounds to an odd number, while EVEN always rounds to an even number, and picking the wrong one for a specific formatting or calculation need is an easy mix-up
EVENAlways rounds away from zero to the next even number, the direct counterpart to ODD.ROUNDRounds to the nearest value using standard rounding rules, rather than always targeting an odd number like ODD.CEILINGRounds up to the nearest multiple of a specified significance, a more flexible alternative when a multiple other than an odd number is needed.Does ODD round to the nearest odd number?
No, it always rounds away from zero to the next odd number, even if a closer odd number exists in the other direction. ODD(2) returns 3, not 1, even though both are technically 'odd numbers near 2'.
What does ODD do with a negative number?
It rounds away from zero, so ODD(-2) returns -3, following the same away-from-zero rule as positive numbers.
What's the difference between ODD and EVEN?
ODD always rounds to the nearest odd number away from zero, while EVEN always rounds to the nearest even number away from zero.
Need to translate a formula using ODD?
Use our translator to convert your complete formula