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 Enter 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 Enter 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.
Summary
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 Aawexcel.com.
Video Tutorial
In this video, you will learn how to use the ABS Function in Excel.
Read Ahead:
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?
Deepak is an Excel enthusiast and data analyst with over 5 years of experience in the field. I’m a renowned author for AAW Excel who connects with a committed group of Excel users by imparting his professional knowledge and helpful advice. No matter your level of Excel proficiency, my articles and tutorials will teach you something new and beneficial. Connect me via my social links!… Mastodon & More!
