At last, we can see the VALUE error because the ABS function will throw a VALUE error If the supplied argument is non-numeric.As we can see that in the second row, we have a negative number by using the ABS function, we have converted a negative number to a positive number, and the positive number remains unchanged.We will get the below output as follows.In the above screenshot, the first row contains a positive number, so there is no difference, and the ABS function returned the absolute value of the number.Press ENTER we will get the output as follows.Use ABS formula as =ABS(A2) as shown in the below screenshot.
![absolute value graph absolute value graph](https://i.ytimg.com/vi/O4YtlXfwHvE/maxresdefault.jpg)
![absolute value graph absolute value graph](http://alg2project10.weebly.com/uploads/4/2/2/7/42275155/2197471.png)
Let’s understand the working of excel Absolute Value with some examples. The given negative number will be returned as an absolute positive number.Ībsolute Value in Excel is very simple and easy to use.Select the negative number on the cell as shown in the below screenshot.We will get the ABS function dialogue box as shown below.Click on the first function called ABS.Click on the Math & Trig option so that we will get the list of functions which is shown in the below screenshot.
![absolute value graph absolute value graph](https://media.cheggcdn.com/media/9f3/s1023x275/9f3e5f13-0804-4257-8cb7-39635b011618/image.png)
#Absolute value graph how to#
In Microsoft excel, the ABS function comes under the category of Math and Trigonometric, where we can find the Math and Trigonometric in the Formula menu we will see how to use the ABS function by following the below steps. Number – which is used to get the absolute value of the number.The Absolute Value Formula in excel has one argument: Excel functions, formula, charts, formatting creating excel dashboard & others