Excel ABS function
The ABS function returns the absolute value of a number. Negative numbers will be converted to positive with this function, but positive numbers and zero number will be unaffected.
The ABS function returns the absolute value of the given number.
In this section, I provide some practical applications for using the ABS function in Excel.
Explain: Convert the number in A2 to absolute value (positive value).
You can drag the fill handle down to the cells which you want to apply this formula.
Get the absolute sum of numbers in a range.
Array formula syntax:
Press Shift + Ctrl + Enter keys at the same time to get the correct calculation
Take getting absolute sum of numbers in A2:A7 as instance, enter formula
And press Shift + Ctrl + Enter keys simultaneously to get the correct result.
1. you also can use this formula =SUMPRODUCT(ABS(A2:A7)) and press the Enter key to get absolute sum.
2. If you want to get absolute average value of numbers in a range, use this array formula
and press Shift + Ctrl + Enter keys simultaneously.
Number1, number2: Required. The two numbers whose absolute difference you want to get.
Take below screenshot for instance：
Calculate the absolute difference of A2 and B2, use this formula
Tip: if you want to calculate the absolute difference between two times, use =ABS(number1-number2), and format the results to time.