Spread Formula Reference
ODD
Formula Functions > Functions M to Q > ODD

This function rounds the specified value up to the nearest odd integer.

Syntax

ODD(value)

Arguments

The argument can be any numeric value.

Remarks

Regardless of the sign of the number specified by the argument, the number is rounded away from zero.

Data Types

Accepts numeric data. Returns numeric data.

Examples

ODD(A3)

ODD(R1C2)

ODD(4) gives the result 5

ODD(-2.5) gives the result -3

Version Available

This function is available in product version 1.0 or later.

See Also

CEILING | EVEN | FLOOR | ISODD | Math and Trigonometry Functions