Skip to content

How to Use ABS Function in Excel?

Listen to this article.
ABS FunctionPin
ABS Function

ABS Function in Excel: In Excel, we can perform various mathematical operations using its built-in formulas and functions. Sometimes, you want to change the negative values into positive values in your Excel worksheet, at that time what will you do to quickly finish it? Searching for the negative values in the spreadsheet and changing them manually is quite frustrating.

Instead of doing it manually, you can use the ABS function in Excel. Further, we have described the usage of the ABS function with practical examples. We assure you that you will be well-versed in the ABS function at the end of this article. Get the official version of MS Excel from the following link:

Use Excel ABS FunctionPin
Use Excel ABS Function

Description of ABS Function

  • It is one of the built-in functions in Microsoft Excel.
  • The ABS (Absolute) function returns the absolute value of a number.
  • A number without its sign is known as the absolute value of a number. In other words, the ABS function removes the minus sign(-) from a negative number and returns it as a positive number while positive numbers remain unchanged.


  • Here, you will see the syntax of the ABS function.
  • To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
  • Once you enter the formula, just click on the Enter button to get the result.


Argument Explanation

  • Number: Number is the numeric value for which we want to calculate the Absolute value in Excel.

Practical Examples

Let’s look at some practical examples of ABS functions and explore how to use them in the Excel spreadsheet.

  • Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
  • For example, we have entered the negative value in Cell B3, as shown in the below screenshot.
Input valuePin
Input value
  • Then, we have to apply the above-mentioned formula and hit the Enter button in order to get the absolute value.
Enter the formulaPin
Enter the formula
  • Once you have executed the formula, you will get the result, as shown in the following screenshot.
  • Let’s see another example to make it clear. In the following image, you will see that we have given both positive and negative values in the range B3:B7.
  • You need to know that, the ABS function will not affect the positive numbers and zero.
Input rangePin
Input range
  • After applying the ABS function to all the values, you will get the result, as shown in the below screenshot.


I hope that this article helped you to know the usage of ABS Function in Excel with detailed practical examples. Don’t forget to drop your worthwhile Feedback. To learn more about Excel functions, then visit our webpage

Video Tutorial

In this video, you will learn how to use the ABS Function in Excel.

Read Ahead:


Leave a Reply

Your email address will not be published. Required fields are marked *

Share to...