ODD

ODD(number)

Returns the number rounded to the nearest odd integer.

number

The number you want to round up or down.

REMARKS

* For an illustrated example refer to the Rounding Functions page.
* Positive numbers are rounded up.
* Negative numbers are rounded down.
* If "number" is an odd integer, there will be no rounding.
* If "number" is not numeric, then #VALUE! is returned.
* You can use the ROUND function to round to a certain number of decimal places or 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

	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("-22.9") = -23
9	=ODD("some text") = #VALUE!

1 - What is the nearest odd number to 13.
2 - What is the nearest odd number to -8.
3 - What is the nearest odd number to 20.
4 - What is the nearest odd number to 0.
5 - What is the nearest odd number to -1.
6 - What is the nearest odd number to -23.2.
7 - What is the nearest odd number to -22.9.
8 - What is the nearest odd number to the text "-22.9".
9 - If number is not numeric.