Documentation/Calc Functions/ABS

Function name:
ABS

Category:
Mathematical

Summary:
Calculates the absolute value or modulus of a real number.

Syntax:
ABS(Number)

Returns:
Returns a non-negative, real number which is the absolute value of the real number passed as argument.

Arguments:
Number is the real number, or a reference to a cell containing that number, whose absolute value is to be calculated.


 * If Number is non-numeric, then ABS reports a #VALUE! error.

Additional details:
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:



Related LibreOffice functions:
IMABS

SIGN

ODF standard:
Section 6.16.2, part 2.

Equivalent Excel functions:
ABS