Returns the absolute value of a real number.
A non-negative, real value.
Number is the real number, or a reference to a cell containing that number, whose absolute value is to be calculated.
The absolute value of a number is its value without the +/- sign. If Number is negative, the corresponding positive value is returned. If Number is not negative, its value is returned without change.
The figure below illustrates the ABS function:
|=ABS(20)||Absolute value of 20||20|
|=ABS(-2)||Absolute value of -2||2|
|=ABS(0)||Absolute value of 0||0|
Related LibreOffice functions:
Equivalent Excel functions: