Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
This article describes the formula syntax and usage of the ABS function.
Description
Returns the absolute value of a number. The absolute value of a number is the number without its sign.
Syntax
ABS(number)
The ABS function syntax has the following arguments:
- number - Required. The real number of which you want the absolute value.
Example
| Formula | Description | Result |
| =ABS(2) | Absolute value of 2 | 2 |
| =ABS(-2) | Absolute value of -2 | 2 |
| =ABS({variable}) | Absolute value of -4 (assuming the value of the {variable} variable is -4 | 4 |
Errors
For a full list of formula errors, please read Formula errors.