Excel: Calculate Percentage Difference Between Numbers

How-to basics · Updated November 19, 2026

If A2 contains the first number and B2 the second, calculate the percentage difference with =ABS(A2-B2)/AVERAGE(ABS(A2),ABS(B2)), then format the result as a percentage. For example, comparing 80 and 100 gives 22.22%; if you mean the increase or decrease from an earlier value, use a percentage-change formula instead.

Understand which percentage calculation you need

“Percentage difference” is used in two related ways, and choosing the right denominator matters. A symmetric percentage difference compares two values without treating either one as the starting point. It divides the absolute gap by the average size of the two values. Reversing the order of the inputs therefore produces the same result.

Percentage change measures movement from a specific starting value to a later value. It divides the change by the original value, so reversing the direction can change the answer. This is usually the right calculation for questions such as “What percentage did sales grow?” or “How much did the price fall?”

For positive numbers, the symmetric formula in the opening paragraph is equivalent to dividing the gap by the arithmetic mean of the two numbers. Using the average of their absolute values in the formula also keeps the denominator positive when one or both inputs are negative. If both inputs are zero, however, the denominator is zero and the calculation is undefined.

Calculate percentage difference step by step

  1. Enter the two values you want to compare in adjacent cells, such as A2 and B2.
  2. In C2, enter =ABS(A2-B2)/AVERAGE(ABS(A2),ABS(B2)). This calculates the absolute gap and divides it by the average magnitude of the inputs.
  3. Select C2, then choose Home > Number > Percent Style. Excel displays the decimal result as a percentage.
  4. If needed, use Increase Decimal or Decrease Decimal in the Home tab’s Number group to control how many decimal places appear.

With 80 in A2 and 100 in B2, the gap is 20 and the average magnitude is 90, so the result is 20 divided by 90, or 0.2222 recurring. Percentage formatting displays approximately 22.22%. If you swap the two values, the result stays 22.22%, which is a useful check that you are calculating a symmetric difference.

For a list, enter the first pair in row 2 and fill the formula down for each row of matching values. Double-click the fill handle at the lower-right corner of C2 to copy it down alongside a continuous data set, or drag the handle to the last row. Excel adjusts the relative references for each row.

Calculate percentage change from an original value

When one number is the baseline and the other is the new value, preserve that direction in the formula. Suppose C2 contains the original value and D2 contains the new value. In E2, enter =(D2-C2)/C2, then format E2 as a percentage. With an original value of 80 and a new value of 100, the increase is 20 divided by 80, or 25%.

If the original value is 100 and the new value is 80, the same formula returns -20%. The minus sign communicates a decrease. If you only want the size of the change and do not need to distinguish an increase from a decrease, with the original in C2 and the new value in D2, use =ABS(D2-C2)/C2. This returns 20% for either direction, so it should not replace a signed change when direction matters.

Percentage changes are not generally reversible by changing the sign. A rise from 80 to 100 is 25%, but a fall from 100 back to 80 is 20%. Each calculation uses a different starting value as its denominator. This explains why a percentage loss followed by the same percentage gain does not necessarily return a value to its starting point.

Format and interpret the result correctly

Excel stores a percentage as a decimal number: 0.25 is displayed as 25% when percentage formatting is applied. The formatting changes how the value appears, not the underlying calculation. This means you can still use the result in other formulas, such as a chart or a summary calculation.

Do not multiply the formula by 100 if you are going to apply Percentage formatting. For example, with 80 and 100 in A2 and B2, =ABS(A2-B2)/AVERAGE(ABS(A2),ABS(B2)) returns about 0.2222, which Excel displays as 22.22% when formatted as a percentage. Multiplying that result by 100 and then applying percentage formatting would display 2,222.22%, an incorrect presentation.

Choose decimal places to suit the precision of the data. For rounded prices or broad comparisons, a whole percentage may be readable; for measurements or small differences, two or more decimal places may be useful. More displayed digits do not make the original measurements more precise, so avoid implying certainty that the source data does not support.

Handle zero values, negatives, and missing data

If both values are zero, the symmetric calculation divides by zero and Excel returns #DIV/0!. That is not a formatting problem: there is no nonzero average magnitude to use as the denominator. Decide how your report should represent this case. You might label the comparison “not applicable,” leave the result blank, or define two zero values as a zero difference for your particular analysis.

For percentage change, an original value of zero also makes the calculation undefined. A change from zero to 10 cannot be expressed as a finite percentage increase relative to zero. Do not silently replace the denominator with a different number; explain the special case or report the absolute change separately. If zero is a legitimate input, check it before calculating or handle it in a separate reporting rule.

Negative values can appear in balances, temperatures, and profit-and-loss data. The symmetric formula using absolute magnitudes produces a nonnegative comparison when the average magnitude is not zero. But crossing zero may make a percentage hard to interpret: a change from -10 to 10 is a difference of 200 relative to an average magnitude of 10, or 2,000%. In such cases, the absolute difference and the context may be clearer than the percentage alone.

Blank cells and text entries can also lead to confusing output. Before filling a formula down a large range, check that both comparison cells contain valid numbers and that blanks do not represent missing observations. A blank that means “not measured” is different from a real value of zero.

Common formula mistakes to avoid

  • Using the wrong baseline: The symmetric difference uses an average denominator; percentage change uses the original value. Decide whether either value is the designated starting point.
  • Forgetting the absolute value: In a symmetric comparison, ABS prevents the order of the two values from producing a negative difference. In a signed percentage-change formula, a negative result can be meaningful and should usually remain.
  • Mixing up formatting and arithmetic: Use the decimal result and apply Percentage formatting. Multiplying by 100 as well can inflate the displayed result by a factor of 100.
  • Comparing unlike units: A percentage does not make two measurements meaningfully comparable if one is in dollars and the other is in thousands of dollars, or if the values represent different quantities. Convert units and verify that each pair describes the same measure.
  • Ignoring the sign convention: For change, write down which cell is old and which is new. Swapping them changes the sign and may change the percentage substantially.

Choose the right comparison for your data

Use percentage difference when the two values have equal status and you want a symmetric measure of how far apart they are. Examples include comparing two independent measurements or two quoted values when neither is naturally the baseline. Use percentage change when comparing before and after, actual versus prior period, or old price versus new price.

For example, a product’s price changing from $80 to $100 is a 25% increase because the original $80 is the baseline. Describing $80 and $100 as differing by 22.22% answers a different question: it compares their gap with their average. State which method you used in a report, especially when the result may be interpreted as growth, decline, or performance.

For values close to zero, percentages can become very large and distract from the actual difference. In those cases, show the absolute change alongside the percentage, or report only the absolute change if that better reflects the scale of the data. The useful measure depends on what the reader needs to compare, not just on which formula is easiest to enter.

Frequently Asked Questions

How do I calculate percentage difference between two cells in Excel?
With the values in A2 and B2, enter =ABS(A2-B2)/AVERAGE(ABS(A2),ABS(B2)) in another cell, then apply Percentage formatting. For 80 and 100, the result is 22.22%.

Is percentage difference the same as percentage change?
No. Percentage difference is symmetric and uses the average magnitude of both values as its denominator. Percentage change has a defined starting value and divides by that original value, so it measures an increase or decrease from a baseline.

Why does Excel show #DIV/0!?
The formula’s denominator is zero. For the symmetric formula, this happens when both values are zero; for percentage change, it happens when the original value is zero. Decide how to describe that special case rather than treating it as an ordinary percentage.

Should I multiply the result by 100?
No, not if you apply Percentage formatting. Excel displays a stored decimal such as 0.25 as 25%. Multiplying by 100 as well would make the displayed percentage 100 times too large.

How do I show a decrease as a positive percentage?
For a change from the original value in C2 to the new value in D2, use =ABS(D2-C2)/C2 when you want the magnitude without direction. Keep =(D2-C2)/C2 when the minus sign is important because it identifies a decrease.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.