Percentage Difference Calculator

Percentage Difference Calculator

Compare two values and find the difference

Percentage Difference vs. Percentage Change

This is where most people trip up, so let’s sort it out before anything else.

Percentage difference compares two values without assigning a direction. It uses the average of the two values as the denominator. You use it when there’s no clear “original” and “new” value — for example, comparing the price of the same product at two different stores.

Percentage change has a direction. It measures how much Value 2 changed relative to Value 1. Value 1 is the baseline. Use this when you’re tracking change over time — like revenue this quarter vs. last quarter, or a test score before and after studying.

Here’s a quick example to make it concrete:

Say a product costs $80 at Store A and $100 at Store B.

  • Percentage difference: |100 – 80| / ((80 + 100) / 2) × 100 = 20 / 90 × 100 = 22.2%
  • Percentage change (B relative to A): (100 – 80) / 80 × 100 = 25%

Same two numbers, different results. The percentage difference (22.2%) is symmetric — it doesn’t matter which store you call Value 1. The percentage change (25%) depends entirely on which value you treat as the baseline.

How the Calculation Works

Percentage Difference Formula

Percentage Difference = |V1 - V2| / ((|V1| + |V2|) / 2) × 100

The denominator is the average of the two values (sometimes called the midpoint). This is what makes it symmetric.

Worked example: A pharmaceutical company tests a drug on two groups. Group A has an average blood pressure of 128 mmHg, Group B has 142 mmHg.

  • |128 – 142| = 14
  • Average = (128 + 142) / 2 = 135
  • Percentage difference = 14 / 135 × 100 = 10.37%

Neither group is the “original.” The 10.37% reflects the spread between them using a neutral midpoint.

Percentage Change Formula

Percentage Change = (V2 - V1) / |V1| × 100

V1 is your baseline. A positive result means an increase; negative means a decrease.

Worked example: Your website had 4,200 visitors in March and 5,100 in April.

  • (5,100 – 4,200) / 4,200 × 100 = 900 / 4,200 × 100 = +21.43%

Traffic increased by 21.43% month over month.

How to Interpret Your Results

Percentage difference gives you a neutral measure of how spread apart two values are. There’s no “good” or “bad” — it just tells you the magnitude of the gap relative to their average.

Percentage change is directional. Positive means growth or increase, negative means decline or decrease. The further from zero, the bigger the shift.

A few things to watch:

  • If Value 1 is 0, percentage change is undefined (you can’t divide by zero). The calculator shows “N/A” in that case.
  • If both values are 0, both metrics are 0%.
  • Very small base values can produce huge percentages. Going from 1 to 2 is a 100% change, even though the absolute difference is just 1.

How to Calculate Percentage Difference in Excel

Excel doesn’t have a built-in PERCENTDIFF function, but the formulas are simple to write.

Percentage difference (with values in A1 and B1):

=ABS(A1-B1)/AVERAGE(ABS(A1),ABS(B1))

Format the cell as Percentage with 2 decimal places. This gives you the symmetric percentage difference.

Percentage change (B1 relative to A1):

=(B1-A1)/ABS(A1)

Format as Percentage. Positive results show an increase; negative results show a decrease.

A useful gotcha: if you format the cell as a number instead of percentage, Excel will show 0.2143 instead of 21.43%. Always check your cell format. In the Home tab, click the % button in the Number group, or press Ctrl+Shift+%.

For a full walkthrough with examples, Spreadsheet Planet has a detailed tutorial on calculating percentage difference in Excel that covers common table scenarios.

Common Mistakes to Avoid

Using percentage change when the values have no natural order. If you’re comparing the salaries of two employees, there’s no “original” salary — neither is the baseline. Use percentage difference instead.

Forgetting the absolute value in the denominator. The denominator in the percentage difference formula uses |V1| + |V2|, not V1 + V2. With negative values, the plain sum could be zero even when the values are not equal.

Mixing up the direction. Percentage change depends on which value you put in V1. (100 – 80) / 80 = 25%, but (80 – 100) / 100 = -20%. The two answers aren’t the same in magnitude, because the denominator changes. Always be clear about what your baseline is.

Calling a large percentage change “significant” without context. A 50% change from 2 to 3 is very different from a 50% change from 200,000 to 300,000. Always look at the absolute difference alongside the percentage.

Using percentage change when the base value is 0 or very close to 0. The result becomes meaningless or undefined. If last month’s sales were $0, you can’t meaningfully express this month’s sales as a percentage change.

FAQ

What is the difference between percentage difference and percentage change?
Percentage difference is symmetric — it uses the average of both values as the denominator and doesn’t imply direction. Percentage change is directional — it measures how much Value 2 differs from Value 1 as a reference point. Use percentage difference when comparing two items at the same point in time. Use percentage change when tracking something over time or against a baseline.

Can percentage difference be negative?
No. Percentage difference always uses the absolute value of the numerator, so it’s always zero or positive. Percentage change, however, can be negative — it means Value 2 is lower than Value 1.

What if my base value is zero?
Percentage change cannot be calculated when Value 1 is zero (division by zero). Percentage difference also becomes undefined if both values are zero, though if only one is zero, the formula still works.

How do I calculate percentage difference in Excel?
Use =ABS(A1-B1)/AVERAGE(ABS(A1),ABS(B1)) and format the cell as Percentage. For percentage change, use =(B1-A1)/ABS(A1) formatted as Percentage.

Why does the percentage difference formula use the average instead of one of the values?
Because percentage difference is meant to be symmetric. If you used V1 as the denominator, the result would change depending on which value you called V1 and which you called V2. The average eliminates that problem.

When should I use percentage difference vs. percentage change?
Use percentage difference when comparing two things with no clear baseline — two prices, two measurements, two test results at the same time. Use percentage change when one value is a starting point and the other is a result or outcome — before vs. after, last year vs. this year.

Related Articles / Calculators:

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.