Saturday, 29 June 2019

How to use excel formula for calculate difference between two values

To calculate the absolute differences, you just need one of below formulas, paste one of below formulas to the blank cell you want to place the result, press Enter key, and drag fill handle over cells needed this formula.


=ABS(A2-B2)

=IF(B2>=A2,B2-A2,A2-B2)

doc abs difference 2


Note: if you want to calculate the absolute difference between times, you only can apply =ABS(A2-B2) and then format values as time

No comments:

Post a Comment