The ODD function returns number rounded to the nearest odd integer.



Note: The ODD function rounds a supplied number away from zero, i.e. rounds a positive number up and a negative number down, to the next odd number.


Argument Description
number The numeric value to round


  A B C
1 Formula Result Notes
2 =ODD(1.5) 3 Rounds 1.5 up to the nearest odd integer
3 =ODD(2) 3 Rounds 2 up to the nearest odd integer
4 =ODD(-2) -3 Rounds -2 up to the nearest odd integer; away from zero

Common Function Error(s)

Problem What went wrong
#VALUE Occurs if number is nonnumeric