How to use ABS function in Excel?

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:

How to use ABS function in Excel
Passing the positive number and we are getting back the same. No change as its absolute value is same.



How to use ABS function in Excel
Passing the negative number (-17) and we are getting back the absolute number (17).



How to use ABS function in Excel
Passing the value by the cell reference. Here abs function uses the value that is present in the cell C2.



How to use ABS function in Excel
Passing the value by the cell reference (A1). Here abs function absolute value of 100% i.e 1 as 100% means 100/100 = 1.
How to use ABS function in Excel
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.

Leave a Reply