ODD

Returns number rounded up to the nearest odd integer.

Syntax

ODD(number)

Number is the value to round.

Remarks

If number is nonnumeric, ODD returns the #VALUE! error value.
Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an odd integer, no rounding occurs.

Example

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)