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.
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.
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.
Then enter the formula
Figure 3. Showing the result of the Excel ABS function