ODD

Rounds a number up to the nearest odd integer to ensure results meet odd-number requirements.

The ODD function rounds a number up and returns the nearest higher odd integer. If the input number is already an odd number, it remains unchanged. The function accepts numeric values or cell references as arguments and is useful in calculations where results must conform to odd-number requirements.

Syntax

ODD(value)

Arguments

value - The input number to be rounded off (Required).

Example

ODD(Column)

In the example below, the ODD measure is created using the ODD function, which rounds the values in MEASURE 2 to the nearest higher odd number.

Applying ODD Function