How to use ABS function in Excel
MS Excel Functions – ABS
What does the ABS function do?
It removes or ignores the negative sign and gives the value as positive for any number.
What to type in a cell of a Excel sheet?
This function can only have one argument and that one argument can be any number, cell reference or range.
“=ABS(Value)” or
“abs(Value)” or
“=ABS(Cell reference)” or
“=ABS(Cell range)”
When to use this function?
When we don’t want negative sign of the values. We only need the value as the positive number.
Examples:
![]() |
Passing the positive number and we are getting back the same. No change as its absolute value is same. |
![]() ![]() ![]() |
Passing the negative number (-17) and we are getting back the absolute number (17). |
![]() ![]() ![]() |
Passing the value by the cell reference. Here abs function uses the value that is present in the cell C2. |
![]() ![]() ![]() |
Passing the value by the cell reference (A1). Here abs function absolute value of 100% i.e 1 as 100% means 100/100 = 1. |
![]() ![]() ![]() |
Passing the cell range gives the absolute values in return. And when the cells are empty, absolute values are returned as 0. |
Also read, How to use Sum Function in Excel?
Thank you. Please share your feedback in the comments.