Spread Formula Reference
ABS
Formula Functions > Functions A to C > ABS

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