< Back

ABS function

Sat Dec 15, 2018 7:47 am

ABS function

This article describes the formula syntax and usage of the ABS function in Microsoft Excel.

Description Returns the absolute value of a number. The absolute value of a number is the number without its sign.

Syntax ABS(number)

The ABS function syntax has the following arguments:
  • Number Required. The real number of which you want the absolute value; or the cell reference which contains the number
Example These are the results that you can expect from this formula. You can copy the Formula into excel and check the results.





Absolute value of 2



Absolute value of -2

You can also use a cell reference for this formula. Example: =ABS(A2) gives you the result for value in cell A2.