SpreadJS 14
Formula Reference / Formula Functions / Math and Trigonometric Functions / 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

    See Also