Sign up for free
Functions

ODD

Returns the smallest odd integer that is greater than or equal to the given number. For positive numbers, it rounds up; for negative numbers, it rounds away from zero to the next odd integer.

Parameter List

Syntax
ODD(number)
number

The numeric value to round to the nearest odd integer. For example: 2.1, -3.7, A1, or any numeric expression.

More details

ODD always rounds away from zero to the next odd integer. For positive numbers, this means rounding up (e.g., 2.1 becomes 3). For negative numbers, this means rounding down (e.g., -2.1 becomes -3). If the number is already odd, it returns the number unchanged.

Examples

ODD() returns 1