Percentage Difference Calculator: Two Numbers
- Number A
- 80
- You entered
- Number B
- 60
- You entered
This calculator works out the percentage difference between two numbers, which tells you how far apart they are relative to their average. You enter any two positive numbers, and you get back a single percentage that shows the size of the gap between them, independent of which number is larger. The result is always positive and is commonly used to compare two measurements, prices, or quantities where neither value is considered the “original” or “baseline.”
Formula
The percentage difference between two numbers is calculated with this formula:
Percentage Difference = (|A − B| / ((A + B) / 2)) × 100
- A = first number (any unit, but both numbers must use the same unit)
- B = second number (same unit as A)
- |A − B| = absolute difference between the two numbers (always positive)
- (A + B) / 2 = the average of the two numbers
The result is a percentage that expresses the absolute difference as a fraction of the average of the two numbers. Because the denominator is the average, the result is symmetric: swapping A and B gives the same answer. This is what distinguishes percentage difference from percentage change, which uses one of the numbers as the base.
Worked Example
Using the default values from the calculator above, let A = 80 and B = 60.
- Find the absolute difference: |80 − 60| = 20
- Find the average: (80 + 60) / 2 = 140 / 2 = 70
- Divide the difference by the average: 20 / 70 = 0.285714…
- Multiply by 100 to get a percentage: 0.285714 × 100 = 28.5714%
Rounded to two decimal places, the percentage difference is 28.57%. The calculator above gives the same result, confirming the formula is applied correctly.
When to Use Percentage Difference vs. Percentage Change
A common source of confusion is mixing up percentage difference with percentage change. They answer different questions:
- Percentage change tells you how much a value has increased or decreased relative to its original value. The formula is (New − Old) / Old × 100. It has a sign (positive or negative) and is used when there is a clear “before” and “after,” like a price going from $50 to $60.
- Percentage difference tells you how far apart two values are relative to their average, with no direction. It is always positive and is used when comparing two values without a baseline, like comparing the heights of two people or the fuel economy of two cars.
For example, if a product costs $50 in one store and $60 in another, the percentage difference is (|50−60| / 55) × 100 = 18.18%. The percentage change from $50 to $60 would be 20%, but that implies the $50 price is the baseline, which may not be meaningful when comparing two independent prices.
How to Read the Result
The percentage difference gives you a sense of the relative gap between the two numbers. A small percentage (like 2%) means the numbers are very close; a large percentage (like 80%) means they are far apart. Because the denominator is the average, the maximum possible percentage difference approaches 200% (when one number is near zero and the other is large). In practice, values above 100% are rare but possible when one number is more than three times the other.
Note that the result is unitless—it does not matter if you are comparing lengths in meters, weights in kilograms, or prices in dollars, as long as both numbers use the same unit. The percentage is the same regardless of the scale of the numbers. For instance, comparing 100 and 150 gives 40%, and comparing 10 and 15 also gives 40%.
Common Mistakes and How to Avoid Them
- Using the wrong denominator: Some people divide by the smaller number or by one of the numbers instead of the average. This gives a different, larger result. Always use the average of the two numbers.
- Forgetting the absolute value: If you do not take the absolute difference, you might get a negative result. Percentage difference is always positive by definition.
- Mixing units: If one number is in meters and the other in centimeters, convert them to the same unit first. Otherwise the difference is meaningless.
- Rounding too early: Rounding the intermediate steps can change the final result. Keep full precision until the final step, then round to the desired number of decimal places.
- Confusing with percentage error: Percentage error uses the true or accepted value as the denominator, not the average. They are different concepts.
Limitations of the Percentage Difference Formula
The formula works best when both numbers are positive and reasonably similar in magnitude. If one number is zero or negative, the formula becomes problematic:
- If one number is zero, the average is positive but the difference equals the other number, so the result is always 200%. That is mathematically correct but not very informative—it just says “one is zero, the other is not.”
- If both numbers are negative, the average is negative, and the result can be misleading or undefined. The formula is not designed for negative values.
- If the numbers are extremely close to zero (e.g., 0.0001 and 0.0002), the percentage difference is large (66.67%) even though the absolute difference is tiny. This is a known quirk of relative measures.
For these edge cases, consider using the absolute difference instead, or switch to percentage change if one value is a clear baseline.
Frequently Asked Questions
What is the difference between percentage difference and percentage change?
Percentage change uses the original value as the denominator and has a sign, showing increase or decrease. Percentage difference uses the average of the two numbers as the denominator and is always positive, showing only the relative gap. Use percentage change when there is a before and after; use percentage difference when comparing two independent values.
Can percentage difference be negative?
No. By definition, percentage difference uses the absolute value of the difference, so the result is always zero or positive. If you see a negative percentage, you are likely calculating percentage change instead.
What does a percentage difference of 0% mean?
It means the two numbers are exactly equal. The absolute difference is zero, so the percentage is zero regardless of the average.
How do I calculate percentage difference in Excel?
Use the formula: =ABS(A1-B1)/((A1+B1)/2)*100, where A1 and B1 are the cells containing your two numbers. Format the cell as a number with decimal places, then multiply by 100 to get the percentage, or use the percentage format directly.
What is the maximum possible percentage difference?
The maximum approaches 200% when one number is zero and the other is positive. For example, comparing 0 and 100 gives (|0−100| / 50) × 100 = 200%. In practice, values above 100% occur when one number is more than three times the other.
Should I use percentage difference when comparing prices?
Yes, if you want to know how far apart two prices are without designating one as the baseline. For example, comparing prices at two different stores is a classic use. However, if you are tracking a price increase over time, use percentage change instead.
Related
Formula used
in a | Number A | - | 80 | 0 in b | Number B | - | 60 | 0 out diff | Percentage difference | % | (abs(a - b) / ((a + b) / 2)) * 100 | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.