ABS Function

How to use the ABS Function in Excel:

The ABS Function returns the absolute value of a number. The absolute value of a number is the number without its sign.


In the example above, cell B2 has the formula =ABS(A2)
This formula returns the absolute value for cell A2 that contains the value -100