How do I use ABS in Excel?
Use ABS when you want to return an absolute value. Enter Number in that order, then add optional arguments when needed.
Excel Function
ABS
Returns absolute value.
ABS(number)Arguments
number
RequiredSpecify a single cell reference.
Practice Preview
Use ABS to return the absolute value of cell D2 (Amount in column D).
Example Table
| # | ASlip ID | BUnit Price | CQuantity | DAmount |
|---|---|---|---|---|
| 2 | S001 | 120.5 | 3 | -361.5 |
| 3 | S002 | 98.2 | 5 | 491 |
| 4 | S003 | 450.7 | 2 | 901.4 |
| 5 | S004 | 300.4 | 4 | 1201.6 |
| 6 | ||||
| 7 | ||||
| 8 |
How to Use (Formula)
=ABS(D2)Result
361.5
Practice This Function
ABS FAQ
Where can I practice ABS?
Use the "Start Function Practice" button to jump straight into ABS drills.
What arguments does ABS use?
The main arguments are Number. Enter them in order.