Formula Functions > Functions A to C > ABS |
This function calculates the absolute value of the specified value.
ABS(value)
ABS(expression)
This function can take either a value or an expression as an argument.
This function turns negative values into positive values.
Accepts numeric data. Returns numeric data.
ABS(R3C2)
ABS(B3)
ABS(-4) gives the result 4
ABS(14-24) gives the result 10
ABS(4) gives the result 4
This function is available in product version 1.0 or later.
SIGN | Math and Trigonometry Functions