Returns number rounded up to the nearest odd integer.
Syntax
ODD(number)
Number is the value to round.
Remarks
- If number is nonnumeric, ODD returns the #VALUE! error value.
- Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an odd integer, no rounding occurs.
Examples
| Formula |
Description (Result) |
| =ODD(1.5) |
Rounds 1.5 up to the nearest odd integer (3) |
| =ODD(3) |
Rounds 3 up to the nearest odd integer (3) |
| =ODD(2) |
Rounds 2 up to the nearest odd integer (3) |
| =ODD(-1) |
Rounds -1 up to the nearest odd integer (-1) |
| =ODD(-2) |
Rounds -2 up to the nearest odd integer (-3) |