The Excel ABS function returns the absolute value (i.e. the modulus) of any supplied number.
The syntax of the function is:
where the number argument is the numeric value that you want the modulus of.
The following spreadsheet shows several examples of the Excel Abs function.
|
Formulas:
|
Results:
|
Further details and examples of the Excel Abs function are provided on the Microsoft Office website.
If you get an error from the Excel Abs function, this is likely to be the #VALUE! error:
| #VALUE! | - | Occurs if the supplied number argument is non-numeric. |