< Go Back

Excel ABS Function

Excel ABS Function

The Excel ABS function helps you to get the absolute value of a number. The ABS stands for “Absolute”. One very important thing is the converting feature of the ABS function. For instance, if a number is in the negative, applying the ABS function will change it into a positive number.




Once you enter the formula in the cell you want the absolute number to convert, you get the exact result. However, there is a common error associated with the use of this formula. When you get this kind of error #VALUE!, it simply means that the data you supplied is not a number. The syntax does not work with non-numeric values.

The ABS function can be applied in any kind of worksheet containing numbers. What this means is that you can use the function anywhere on your data sheet in as much as the spreadsheet contains numbers. The ABS function is under the Math/Trig Function category.

Now, let’s see how it works in a generically formed data. Carefully follow the examples and steps and see how you could model it around your spreadsheet.


Step 1

Let’s assume this is the data you are working with, as shown in the image below.

Figure 1. Specify all data

Then select the cell you want the value to appear. Mind you, it could be anywhere on the spreadsheet.

Step 2

Here, cell B6 has been selected and that is where the ABS value for A1 will appear.

Figure 2. Select an empty cell for the ABS function.

Step 3

Then enter the formula =ABS(A1)

Figure 3. Showing the result of the Excel ABS function


Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment