**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!