Calculates the absolute value or modulus of a real number.
Returns a non-negative, real number which is the absolute value of the real number passed as argument.
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.
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(234.5)||Absolute value of 234.5||234.5|
|=ABS(D1) where D1 contains the value -123||Absolute value of -123||123|
|=ABS(0)||Absolute value of 0||0|
Related LibreOffice functions:
Equivalent Excel functions: