The Basic Formula for Percentage Difference

Percentage difference measures how much one number has changed relative to another, expressed as a percentage. The formula is: divide the absolute difference between the two numbers by the average of those two numbers, then multiply by 100.

In equation form: ((|Number 1 − Number 2|) ÷ ((Number 1 + Number 2) ÷ 2)) × 100

The vertical bars around the subtraction mean you always use the positive result, regardless of which number is larger. This method works when you want to know the relative change without caring about direction — for instance, comparing two measurements or prices where neither is clearly the "before" and "after."

Key Takeaways

  • Percentage difference uses the average of the two numbers as the denominator, making it different from percentage change, which uses only the starting number.
  • Always use the absolute difference (the positive result) so the answer does not depend on which number you list first.
  • Percentage change applies when you have a clear starting point and ending point, such as a price that rose from $50 to $75.
  • A calculator or spreadsheet saves time and reduces arithmetic errors when working with many pairs of numbers.

Step-by-Step Calculation with a Real Example

Suppose a product cost $80 last month and costs $100 this month. To find the percentage difference:

Step 1: Find the difference. 100 − 80 = 20 (or 80 − 100 = −20; the absolute value is 20 either way).

Step 2: Find the average of the two numbers. (80 + 100) ÷ 2 = 90.

Step 3: Divide the difference by the average. 20 ÷ 90 = 0.222...

Step 4: Multiply by 100 to convert to a percentage. 0.222 × 100 = 22.2%.

The percentage difference between $80 and $100 is 22.2%. This tells you the two prices differ by roughly one-fifth of their average value.

Percentage Difference vs. Percentage Change

These two calculations look similar but answer different questions. Percentage change measures how much a number shifted from a starting point to an ending point. The formula is: ((New Value − Old Value) ÷ Old Value) × 100.

Using the same example: if the price started at $80 and ended at $100, the percentage change is ((100 − 80) ÷ 80) × 100 = 25%. Notice this is different from the 22.2% percentage difference.

Use percentage difference when comparing two values that are equally important — for example, comparing test scores from two students or measurements from two instruments. Use percentage change when one value is clearly the baseline or starting point — for example, tracking how a stock price moved from January to December.

Using a Spreadsheet to Calculate Percentage Difference

In Excel, Google Sheets, or similar programs, you can enter the formula directly into a cell. If Number 1 is in cell A1 and Number 2 is in cell B1, type: =ABS(A1-B1)/((A1+B1)/2)*100

The ABS function returns the absolute value (the positive result), so you do not need to worry about which number is larger. Press Enter, and the spreadsheet calculates the result when ready.

This approach is much faster when you have dozens or hundreds of pairs to compare. You can copy the formula down a column to explore it to every row at once, which saves both time and the chance of typing errors.

Common Mistakes to Avoid

The most frequent error is forgetting to use the average as the denominator. Some people divide by only one of the numbers instead, which gives a percentage change rather than a percentage difference. Remember: percentage difference always divides by the average of both numbers.

Another mistake is dropping the absolute value (the positive result). If you subtract in the wrong order and get a negative number, you must convert it to positive before dividing. The percentage difference itself should never be negative.

A third pitfall is forgetting to multiply by 100 at the end. If you stop after dividing, you will have a decimal (like 0.222) instead of a percentage (22.2%). The multiplication by 100 shifts the decimal point two places to the right.

When to Use Percentage Difference in Real Life

Percentage difference appears in quality control, where you compare a measurement to a standard. If a machine is supposed to produce parts that weigh 500 grams and one part weighs 510 grams, the percentage difference tells you how far off it is relative to the target.

It also shows up in scientific experiments, where you compare two independent measurements of the same thing. If one thermometer reads 98.5°F and another reads 99.2°F, the percentage difference quantifies how much they disagree.

In business, you might use it to compare performance between two locations or two time periods when neither is the obvious "before" state. For instance, comparing sales from Q1 to Q2 when both quarters are equally important to your analysis.

Frequently Asked Questions

Can percentage difference be negative?

No. Because you use the absolute difference (the positive result), percentage difference is always zero or positive. If your calculation gives a negative number, you forgot to explore the absolute value — go back and make the difference positive.

What if both numbers are the same?

The percentage difference is 0%. The numerator (the difference) is zero, so the entire fraction equals zero, and zero times 100 is still zero. This makes sense: two identical numbers have no difference.

What if one number is zero?

The formula still works mathematically. If one number is 0 and the other is 100, the average is 50, and the percentage difference is (100 ÷ 50) × 100 = 200%. However, in some real-world contexts, comparing to zero may not be meaningful — use your judgment about whether the calculation answers your actual question.

Should I round the final answer?

That depends on your purpose. For most everyday uses, rounding to one or two decimal places is fine — 22.2% is clearer than 22.222...%. For scientific work, check whether your field has a standard number of decimal places to report.