Returns
number rounded up to the nearest odd integer.
Syntax
ODD(number)
Argument | Description | Remarks |
|---|
number | The value to round. | -
Regardless of the sign of this argument, a value is rounded up when it is adjusted away from zero.
If
number is an odd integer, no rounding occurs.
-
If this argument is nonnumeric, this function returns the #VALUE! error value.
|
Example
To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.
 | | 1 | | 2 | | 3 | | 4 | | 5 | | 6 |
| | A | B | | 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) |
|
