< Back
ABS function
Post
ABS function
This article describes the formula syntax and usage of the ABS function in Microsoft Excel.
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:
You can also use a cell reference for this formula. Example: =ABS(A2) gives you the result for value in cell A2.
This article describes the formula syntax and usage of the ABS function in Microsoft Excel.
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; or the cell reference which contains the number
| Formula | Description | Result |
| =ABS(2) | Absolute value of 2 | 2 |
| =ABS(-2) | Absolute value of -2 | 2 |