
Kalpesh Agrawal
Excel ABS function
ABS function returns the absolute value of a number.
In other words, an Absolute number is a number without its sign.
ABS (number)
number | Required. Enter the number of which you want the absolute value. |
Example:
Formula | Description | Answer |
=ABS(4) | Absolute value of 4 | 4 |
=ABS(-103) | Absolute value of -103 | 103 |
=ABS(A2) Where A2 cell contain value (-3) | Absolute value of -3 | 3 |
Written by: Kalpesh Agrawal (Jr. Actuarial Officer)