Spread Formula Reference
Formula Functions / Functions A to C / ABS
In This Topic
    ABS
    In This Topic

    This function calculates the absolute value of the specified value.

    Syntax

    ABS(value)

    ABS(expression)

    Arguments

    This function can take either a value or an expression as an argument.

    Remarks

    This function turns negative values into positive values.

    Data Types

    Accepts numeric data. Returns numeric data.

    Examples

    ABS(R3C2)

    ABS(B3)

    ABS(-4) gives the result 4

    ABS(14-24) gives the result 10

    ABS(4) gives the result 4

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    SIGN | Math and Trigonometry Functions