ABS function in Excel
ABS returns the absolute value of a number.
Syntax
=ABS(number)
| Argument | Required? | What it is |
|---|---|---|
| number | Required | The number or cell to work with. |
Practise ABS in a live spreadsheet
There is no dedicated lesson yet. Browse all lessons.
Related math functions
- SUMAdds all the numbers in a range.
- SUMIFAdds the cells that meet one condition.
- SUMIFSAdds the cells that meet several conditions.
- SUMPRODUCTMultiplies matching items and returns the sum of those products.
- ROUNDRounds a number to a given number of digits.
- ROUNDUPRounds a number up, away from zero.
- ROUNDDOWNRounds a number down, toward zero.
- FLOORRounds down to the nearest multiple of significance.