Syntax
ODD(number)
| Parameter | Description |
|---|---|
| number | Parameter of the ODD function. |
Examples
Round up to odd
Formula
=ODD(2)
Returns 3. The next odd integer above 2 is 3.
Already odd
Formula
=ODD(7)
Returns 7. Already an odd integer, so no change.
Fractional input
Formula
=ODD(4.1)
Returns 5. Rounds 4.1 up to the next odd integer.
Common Errors
#VALUE!
Occurs when the argument is non-numeric text.
Tips
Printing right-hand pages
In booklet printing, right-hand (recto) pages are odd-numbered. Use ODD to calculate the next right-hand page number.
Rounds away from zero
ODD(-2.5) returns -3. Like EVEN, it always rounds away from zero, increasing the absolute value.
Check odd/even with MOD
To test if a number is already odd: =MOD(A1,2)=1. Use ODD only when you need to force a value to be odd.
Try ODD in Viztab
Import your data and use ODD with 370+ other formulas. No signup required.
Open Viztab