Spread Formula Reference
Formula Functions / Functions M to Q / ODD
In This Topic
    ODD
    In This Topic

    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