Percentage Difference Calculator
Find the percentage difference between any two numbers instantly—complete with step-by-step math.
Enter Two Values
Find the percentage difference between any two numbers compared to their average.
Complete Guide to Percentage Difference
Everything you need to know: the exact formula, easy 4-step math, spreadsheet shortcuts for Excel and Sheets, real-world examples, and when to use percentage difference.
What Is Percentage Difference?
Imagine you visit two coffee shops on the same street. Cafe A sells a latte for $4.00, and Cafe B sells the same drink for $5.00. How much do their prices differ?
Neither cafe is the "official" starting price. They are just two regular shops side by side. This is exactly when you use percentage difference: when you're comparing two equal things and neither one is the "original" starting number.
Instead of picking one price as the baseline, percentage difference compares the gap between them ($1.00) against the average of the two numbers ($4.50). This gives you an honest, fair comparison of 22.22% no matter which cafe you look at first.
Order Doesn't Matter
Comparing 50 and 60 gives the exact same 18.18% result as comparing 60 and 50. You never have to worry about which number goes first.
Fair Halfway Point
The formula divides by the average of both numbers. This keeps the comparison completely neutral and fair.
Always Positive
Because it measures the physical gap between two values, percentage difference is never negative. It ranges from 0% (identical values) up to 200%.
The Percentage Difference Formula
The percentage difference formula is simple: subtract the two numbers, divide by their average, and multiply by 100.
Here, |A − B| is the difference between your two numbers, and (|A| + |B|) ÷ 2 is their average. For normal positive numbers, this is just your standard average (A + B) ÷ 2.
Math.abs(A - B) / ((Math.abs(A) + Math.abs(B)) / 2) * 100Your Two Numbers
The two values you want to compare. They can be whole numbers, decimals, or even negative values.
The Gap (Difference)
Subtract one number from the other. The vertical bars | | mean absolute value: simply drop any minus sign so the gap is always positive.
The Average (Halfway Point)
Add both numbers together and divide by 2 to find their halfway point. Dividing by this average treats both numbers equally.
Turn Into a Percent
Multiplying by 100 converts the decimal fraction into a standard percentage (%).
If you are comparing negative numbers (such as −20 and −10), our calculator uses absolute values for the average (|A| + |B|) ÷ 2. This keeps the bottom of the fraction positive and avoids dividing by zero or flipping signs backward.
How to Calculate Percentage Difference
Follow these 4 simple steps to calculate the percentage difference between any two numbers by hand or on paper:
Find the Difference
Subtract the two numbers. If you get a negative number, drop the minus sign. You only want the positive gap between them.
Difference = |A − B|Find the Average
Add the two numbers together and divide by 2. This gives you the fair halfway point between them.
Average = (A + B) ÷ 2Divide Difference by Average
Take the difference from Step 1 and divide it by the average from Step 2. This gives you a decimal number.
Ratio = Difference ÷ AverageMultiply by 100
Multiply the decimal number by 100 and add a percent sign (%). You're done!
Percentage = Ratio × 100%How to Calculate Percentage Difference in Excel & Google Sheets
Need to compare columns of numbers in Microsoft Excel or Google Sheets? Use these formulas to calculate percentage difference automatically.
Standard Spreadsheet Formula
Best for prices, test scores, heights, and any standard positive values in cells A2 and B2.
Tip: After pasting, click the % button on your toolbar to format the decimal as a percentage.
All-Number Formula
Handles positive numbers, negative temperatures, and financial losses without dividing by zero or reversing signs.
How it works: ABS() removes minus signs so the denominator is always positive.
3 Easy Steps to Use in Your Sheet:
- Enter your first number in cell A2 and your second number in cell B2.
- Paste the formula above into cell C2 and press Enter.
- Select cell C2 and click the Percent Style (%) button on your spreadsheet toolbar. Double-click the corner handle to drag down for all rows!
Worked Examples & Reference Table
Here is how the formula works across whole numbers, decimals, and zero. Click Load on any row to test it in the calculator above.
Quick Walkthrough: Percentage Difference Between 50 and 60
Let's compare 50 and 60:
| Value A | Value B | Difference | Average | Result | Example Case | Try It |
|---|---|---|---|---|---|---|
| 50 | 60 | 10.00 | 55.00 | 18.18% | Comparing two standard numbers (halfway point is 55) | |
| 25 | 75 | 50.00 | 50.00 | 100.00% | 3-to-1 ratio where the gap equals the average | |
| 100 | 100 | 0.00 | 100.00 | 0.00% | Identical numbers with zero difference | |
| 0 | 50 | 50.00 | 25.00 | 200.00% | Comparing zero to a number (maximum 200% gap) | |
| -50 | 50 | 100.00 | 50.00 | 200.00% | Opposite numbers with the same size | |
| -20 | -10 | 10.00 | 15.00 | 66.67% | Negative numbers compared using their sizes | |
| 12.5 | 15.5 | 3.00 | 14.00 | 21.43% | Everyday decimal numbers and measurements | |
| 40 | 60 | 20.00 | 50.00 | 40.00% | Comparing store prices side-by-side ($40 vs $60) |
Percentage Difference vs. Percentage Change
Percentage Difference
Compares two equal things at the same point in time. Neither number is considered the "original" or "starting" value.
- ✓Order doesn't matter: Comparing 40 to 60 gives the exact same result as comparing 60 to 40.
- ✓Denominator: Divided by the average of both numbers.
- ✓Sign: Always positive (0% or greater).
Percentage Change
Tracks how a single number goes up or down from an old starting value to a new finishing value.
- →Direction matters: An increase is positive (+); a decrease is negative (−).
- →Denominator: Divided strictly by the old starting number.
- →Sign: Can be positive (growth) or negative (drop).
Side-by-Side Example: Prices of $40 and $60
Notice how the math changes depending on whether you're comparing two stores or tracking one store's prices over time:
When to Use Percentage Difference
Percentage difference is the right choice whenever you're comparing two equal things and neither one is the "original" starting number. Here are four common everyday situations:
Comparing Prices Between Stores
Compare quotes from two contractors or check the price of an item at two rival stores without calling either price the "standard" one.
Science Labs & School Experiments
Check how closely two lab measurements or thermometers agree when doing an experiment or testing equipment.
Comparing Team Outputs
Look at the difference in output between two shifts, branches, or classrooms without unfairly declaring one as the benchmark.
Comparing Two Predictions
Check the spread between two different budget estimates or weather forecasts before you know the actual final numbers.
If you are comparing an experiment result to an accepted scientific constant (like the speed of gravity), use Percentage Error. If you are tracking how much something grew or shrunk over time, use Percentage Change.
Frequently Asked Questions
Quick, straight-to-the-point answers about percentage difference, how the formula works, and how to use it in daily life.