ODD function

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.

Examples

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)