opfvalue.blogg.se

With the actual value in A2, expected value in B2, and the tolerance in C2, you build the formula in this way: The problem is that some of the results are negative numbers while you want the difference to always be a positive number:Īnd have the negative numbers converted to positive, leaving the positive numbers unaffected:Īnother common application of the ABS function in Excel is to find whether a given value (number or percentage) is within expected tolerance or not. Supposing, you calculate the difference between two numbers by subtracting one number from the other. In situations when you need to change negative number to positive numbers, the Excel ABS function is an easy solution. Convert negative numbers to positive numbers

But can you think of real-life applications of an absolute formula? The following examples will hopefully help you gain a better understanding of what you are really finding. You now know the concept of absolute value and how to calculate it in Excel. The following screenshot shows our absolute formula in Excel: It can be represented by a value, cell reference or another formula.įor example, to find the absolute value of a number in cell A2, you use this formula:

Where number is the number you want to get the absolute value of.