The ABS function returns the absolute value of a number. The absolute value of zero or a positive number remains the same. The absolute value of a negative number is the same number without the negative sign (the positive version).
Syntax
ABS(Number)
Arguments
| Argument | Data type | Description |
| Number | Number | The number to return the absolute value of. |
The ABS function returns a number.
Excel equivalent
Examples
| Formula | Result |
ABS(-20) | 20 |
ABS(20) | 20 |
ABS(0) | 0 |
