# How to Use ABS Function in Excel?

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:

https://www.microsoft.com/en-in/microsoft-365/excel

## 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.

## Syntax

• 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 button to get the result.

=ABS(number)

### 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.
• Then, we have to apply the above-mentioned formula and hit the  button in order to get the absolute value.
• 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.
• After applying the ABS function to all the values, you will get the result, as shown in the below screenshot.