In this post, you will learn how to use ABS function in Excel.
How to use ABS function in Excel?
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 an Excel sheet?
This function can only have one argument and that one argument can be any number, cell reference or range.
“=ABS(Cell reference)” or
When to use this function?
When we don’t want a negative sign of the values. We only need the value as the positive number.
|Passing the positive number and we are getting back the same. No change as its absolute value is the 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 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?