Percentage Difference Calculator
This percentage difference calculator compares two values when neither one is the obvious starting point. It divides the gap between them by their average, so 40 and 50 give the same 22.22% whichever you enter first. For contrast it also shows the percent change in both directions, along with the absolute difference, the average, the working steps and a bar chart.
How to use the percentage difference calculator
- Enter your two values in the A and B fields. The defaults are 40 and 50.
- Read the percentage difference at the top:
22.2222%. - Below it, the calculator lists the absolute difference (10) and the average (45), the two numbers the result is built from.
- For comparison, it shows the percent change from A to B (+25%) and from B to A (−20%). The bar chart draws A and B side by side.
Swap A and B and the percentage difference stays at 22.2222%. Only the two percent-change lines trade places. That symmetry is the whole point of this measure, and the next sections explain why it matters and when to use it. If one of your numbers really is a “before” and the other an “after,” the percentage change calculator is the right tool instead.
The percentage difference formula
There are three parts, and each has a job.
- |A − B| is the absolute difference: the size of the gap, always positive. The vertical bars mean “ignore the sign,” so 40 − 50 and 50 − 40 both give 10. The absolute value calculator explains the notation.
- (A + B) ÷ 2 is the mean of the two values. It is the reference point, chosen because it treats A and B equally. The average calculator does the same step for longer lists.
- × 100 turns the decimal ratio into a percentage.
You will also see this written as |A − B| ÷ (A + B) × 200. Dividing by the sum and multiplying by 200 is the same as dividing by half the sum and multiplying by 100, so the two forms always agree.
Worked examples
Example: two store prices
One store sells a blender for $18.50 and another sells the same model for $21.00. How different are the prices?
The prices differ by about 12.66%. Neither store is the baseline, so the average is the fair reference. Quoting the percent change instead would give 13.51% or 11.90% depending on which store you started from. To compare different pack sizes rather than one item, use the unit price calculator.
Example: two lab measurements
Two students measure the same sample and record 9.6 g and 10.2 g. How well do the readings agree?
The two readings differ by about 6.06%. In a lab report this is the usual way to compare two trials of equal standing. Round the answer to a sensible precision for the data; the significant figures calculator helps match the result to the inputs.
Example: two town populations
Town A has 12,400 residents and town B has 15,900. What is the percentage difference?
The populations differ by about 24.73%. If the question were “how much bigger is B than A,” the answer would be the percent change from A, about 28.23%. Both are correct for their own question.
Why the formula divides by the average
A percentage needs a base: something to divide by. With percent change, the base is the old value. With two values of equal standing, choosing either one as the base is arbitrary, and the arbitrary choice changes the answer. For 40 and 50:
The average sits between the two values, so the percentage difference always lands between the two percent changes. It is a compromise that does not favor either number. The calculator prints all three so you can see that relationship directly.
When the two values are close together, all three answers are nearly identical. For 100 and 101, the changes are 1% and about −0.99%, and the difference is about 0.995%. The choice of formula starts to matter as the values spread apart, which is exactly when people argue about which number to quote.
The percent difference vs percent change guide goes further into choosing between them, with examples from pricing, science and reporting.
Percentage difference compared with percent change
This table shows how far the measures drift apart as the gap between the values grows.
| A | B | % difference | % change A → B | % change B → A |
|---|---|---|---|---|
| 100 | 101 | ≈ 0.995% | +1% | ≈ −0.99% |
| 90 | 100 | ≈ 10.53% | ≈ +11.11% | −10% |
| 40 | 50 | ≈ 22.22% | +25% | −20% |
| 100 | 150 | 40% | +50% | ≈ −33.33% |
| 50 | 100 | ≈ 66.67% | +100% | −50% |
| 10 | 30 | 100% | +200% | ≈ −66.67% |
| 1 | 100 | ≈ 196.04% | +9,900% | −99% |
| 0 | 5 | 200% | undefined | −100% |
Two patterns stand out. First, the percentage difference never exceeds 200%, even when one value is a hundred times the other. Second, a percentage difference of 100% does not mean one value is double the other; it means one is three times the other (10 and 30). Doubling gives 66.67%. Readers who expect percentage difference to behave like percent change get both of these wrong.
Where percentage difference breaks down
It tops out at 200%
When one value is 0, the gap equals the other value and the average is half of it, so the ratio is always 2, or 200%. Every other pair gives less. That ceiling compresses large gaps: 1 versus 100 and 1 versus 1,000 both land close to 200%, which hides a big real difference. For widely separated values, a ratio (“B is 100 times A”) is clearer.
Both values zero
If A and B are both 0, the average is 0 and the formula divides by zero. Two zeros are identical, so the practical answer is “no difference,” but the formula itself cannot say that.
Values with opposite signs
For −2 and 3, the gap is 5 and the average is 0.5, giving 1,000%, well past the ceiling that applies to positive values. When the values straddle zero the average can be tiny or zero, and the percentage becomes meaningless. Use the absolute difference for data like temperatures in °F or profit-and-loss figures that cross zero.
Common mistakes
- Dividing by one of the values. That gives a percent change, not a percentage difference. The base is the average.
- Forgetting the absolute value. A percentage difference is never negative. If you get −22.22%, you subtracted in one order and kept the sign.
- Using percentage difference for a before-and-after. If prices went from $40 to $50, the headline is “up 25%,” and the percentage increase formula is the right method. The 22.22% figure would understate a change that has a clear direction.
- Reading 100% as “double.” Values in a 2:1 ratio differ by about 66.67%. A 100% difference means a 3:1 ratio.
- Averaging percentage differences across pairs. Each pair has its own average as a base, so the figures do not combine. Recalculate from the raw values.
If what you actually need is “A is what percent of B,” that is a plain ratio, and the what percent of calculator does it in one step.
Frequently asked questions
How do you calculate percentage difference?
Subtract one value from the other and ignore the sign, divide by the average of the two values, and multiply by 100. For 40 and 50: the gap is 10, the average is 45, and 10 ÷ 45 × 100 ≈ 22.22%. Because the average treats both numbers the same way, you get the same answer whichever value you start with.
What is the percentage difference between 40 and 50?
About 22.22%. The absolute difference is 10 and the average is 45, so 10 ÷ 45 = 0.2222…, which is 22.22% when rounded to two decimal places. By comparison, going from 40 to 50 is a 25% increase, and going from 50 to 40 is a 20% decrease.
What is the percentage difference between 100 and 150?
Exactly 40%. The gap is 50 and the average is 125, so 50 ÷ 125 = 0.4. That sits between the percent change from 100 to 150, which is +50%, and the change from 150 to 100, which is about −33.33%. Use 40% when neither value is the baseline.
Is percentage difference the same as percentage change?
No. Percentage change divides the gap by the old value, so it has a direction and depends on which number comes first. Percentage difference divides by the average of the two, so it has no direction and is the same either way round. Use change for before-and-after comparisons and difference for two values of equal standing, like two quotes.
Can percentage difference be more than 100%?
Yes, up to a maximum of 200% for positive values. 10 and 30 differ by exactly 100%, 1 and 100 by about 196.04%, and any positive number compared with 0 by 200%. Values with opposite signs can give larger, unhelpful results because their average is close to zero, so avoid the measure for data that crosses zero.
Does the order of the two numbers matter?
Not for percentage difference. The absolute value removes the sign from the gap, and the average of A and B is the same as the average of B and A, so the result is identical either way. That is the reason the measure exists. Percent change, by contrast, gives different answers depending on which number you treat as the starting point.
How do I calculate percentage difference in Excel?
With the values in A1 and B1, use =ABS(A1-B1)/AVERAGE(A1,B1) and format the cell as a percentage, or multiply by 100 to get the number directly. ABS removes the sign and AVERAGE gives the reference point. Wrap the formula in a check for both cells being zero if your data can contain that case.
Related calculators
Guides that use this calculator
Longer explanations of the method behind it, with worked examples.
Put this calculator on your own site (free)
Copy this into any page. The calculator stays up to date on its own, works on mobile, and carries a small credit link back here.
https://fourfunctioncalculator.com/percentage-difference-calculator/