ODD

ODD(number)

Returns the number rounded to the nearest odd integer.

number

The number you want to round up or down.

REMARKS

* Positive numbers are rounded up.
* Negative numbers are rounded down.
* If "number" is an odd integer, then no rounding takes place.
* If "number" is not numeric, then #VALUE! is returned.
* You can use the ROUND function to round to a specified number of digits.
* You can use the EVEN function to round up to the nearest even number.
* You can use the ISODD function to return the boolean True or False depending if the value is an odd number.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=ODD(13) = 13
2	=ODD(-8) = -9
3	=ODD(20) = 21
4	=ODD(0) = 1
5	=ODD(-1) = -1
6	=ODD(-23.2) = -25
7	=ODD(-22.9) = -23
8	=ODD("some text") = #VALUE!