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

Syntax

=ODD(number)

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.

Arguments

Argument Description
number The numeric value to round

Examples

  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