Everyday math & dates
Percent Difference Calculator
Percent difference compares two values when neither one is the starting point, such as two measurements or two store prices. If one value is clearly the before and the other the after, use percentage change instead.
Your result will appear here.
How it's calculated
Take the absolute difference and divide it by the average of the two values. The answer is the same whichever order you enter them in.
% difference = |A − B| ÷ ((A + B) ÷ 2) × 100
How to do it in Excel
=ABS(A1-B1)/AVERAGE(A1,B1)- Format the result as a percentage.