Use of ABS Function in Excel

In this post, we will see how we can use the abs function in Excel.

ABS Function

ABS is an Absolute function. The ABS function in Excel is used to return the absolute value of a number. It returns only the number without any sign.

Example: if a number is -12 and we apply the abs function on it then it will return only 12.

Syntax of abs function


  • abs is the name of the function.
  • number is the parameter passed in it to get the absolute value.