ODD

Microsoft Datasheet View

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)