Difference Between Percentages in Excel: How to Calculate

How-to basics · Updated November 19, 2026

To find the difference between two percentages in Excel, subtract the earlier percentage from the later one: if A2 contains the old percentage and B2 the new one, enter =B2-A2. That gives the change in percentage points; to find the relative percent change instead, use =(B2-A2)/A2.

Two different meanings of “difference”

The question “What is the difference between 12% and 15%?” can have two valid answers, depending on what you want to measure. The direct subtraction is 3 percentage points: 15% minus 12% equals 3 percentage points. The relative increase is 25%, because the increase of 3 points is one-quarter of the original 12%.

These measures answer different questions. Percentage-point difference tells you how far apart two rates are on the percentage scale. Percent change tells you how large the change is compared with the starting value. In everyday conversation, people sometimes call both answers “a percent difference,” but keeping the terms distinct helps avoid misunderstandings in reports and spreadsheets.

Calculate the percentage-point difference

Use subtraction when you want the absolute gap between two rates, or the change measured in percentage points. For example, assume A2 contains 12% and B2 contains 15%. With the old percentage in A2 and the new percentage in B2, enter =B2-A2. The result is 3 percentage points. Excel stores 12% as 0.12 and 15% as 0.15, so the subtraction returns 0.03, which displays as 3% when the result cell is percentage-formatted.

The sign tells you the direction. A positive result means the second value is higher; a negative result means it is lower. With A2 at 15% and B2 at 12%, the same formula returns -3%, meaning a decrease of 3 percentage points. For clear writing, label this as “-3 percentage points” or “down 3 points,” rather than implying it is a relative decrease of 3%.

To compare the rates without implying direction, take the absolute value. With the two percentages in A2 and B2, enter =ABS(B2-A2). For 12% and 15%, the result is 3 percentage points whether the larger value is in A2 or B2. This is useful for reporting a gap, but it is not a measure of growth.

Calculate relative percent change

When the question is how much the new percentage rose or fell relative to the old percentage, divide the difference by the old value. If A2 contains the old rate and B2 the new rate, enter =(B2-A2)/A2. With 12% in A2 and 15% in B2, the calculation is (0.15 – 0.12) / 0.12 = 0.25, or a 25% increase. Format the result cell as a percentage to display 25%.

Reversing the direction changes the answer. If A2 is 15% and B2 is 12%, the formula returns -20%: the rate fell by 20% relative to its original value. It did not fall by 20 percentage points; the point difference is -3. This is why it matters to identify which value is the baseline before calculating a relative change.

For a sequence of periods, put the earlier rate in one column and the later rate in another. For example, label A1 “Previous” and B1 “Current,” then put each period’s rates in the matching row. Enter the relevant formula in C2 and fill it down. Keep the column heading specific, such as “Change (percentage points)” or “Relative change,” so readers know which calculation the results represent.

Enter and format percentage values correctly

Excel stores a percentage as a decimal proportion: 12% is stored as 0.12. You can type 12% directly into a cell, or enter 0.12 and apply percentage formatting. If you type 12 as a plain number, Excel treats it as twelve, not 12 percent. Subtracting 12 from 15 returns 3; formatting that result as a percentage would display 300%, which is not the intended 3-point difference.

To format a result, select its cell and choose Home > Number > Percent Style. Use the increase or decrease decimal controls in the Number group if you need more or fewer displayed decimal places. Formatting changes how a value appears, not the underlying value or the arithmetic. A result stored as 0.03 may display as 3%, and a result stored as 0.25 may display as 25%.

There is a useful distinction between the underlying numeric result and its label. A subtraction result displayed as 3% is mathematically 0.03, but in a comparison of rates it is usually described as 3 percentage points. Excel will not automatically add the words “percentage points.” Add that wording in a nearby label, heading, or explanatory note to prevent readers from mistaking the result for relative percent change.

Choose the right formula for the question

Before writing a formula, decide what the result needs to communicate. A simple subtraction is appropriate for a gap between two rates or a change in points. A relative-change calculation is appropriate for growth or decline relative to a baseline. The same pair of values can produce both results, so choosing a formula based only on the word “difference” can lead to the wrong interpretation.

  • Use percentage-point difference to say how many points a rate moved, such as a pass rate rising from 70% to 74%: up 4 percentage points.
  • Use relative percent change to describe the size of the movement against the starting rate: that same move is about a 5.71% increase, because 4 divided by 70 is approximately 0.0571.
  • Use an absolute difference when you need the size of a gap but do not care which rate is higher.
  • State the baseline and the direction when reporting a relative change, especially when readers might compare values across different periods or groups.

For the 70%-to-74% example, if the previous rate is in A2 and the current rate is in B2, enter =(B2-A2)/A2 to calculate the relative change. The result is approximately 5.71% when displayed to two decimal places. The percentage-point result is 4 points. Neither figure is a replacement for the other; they describe the movement from different perspectives.

Common mistakes and edge cases

The most common error is treating percentage points and percent change as interchangeable. A move from 20% to 25% is 5 percentage points, but the relative increase is 25% (5 divided by 20). Saying only “it increased by 5%” is ambiguous and may be interpreted as either a five-point rise or a five-percent relative rise.

A second issue is choosing the wrong baseline. Relative change uses the original or previous value as the denominator. If you compare a current value against a target, decide whether the target or the prior value is the meaningful baseline, then label the result accordingly. Swapping the old and new cells can reverse the direction and change the percentage because the denominator changes too.

If the starting percentage is zero, relative percent change is undefined: division by zero has no finite answer. The point difference can still be calculated. For example, a change from 0% to 4% is an increase of 4 percentage points, but there is no meaningful percentage increase relative to zero. In that situation, report the point change or use another clearly defined comparison rather than presenting a fabricated relative rate.

Very small starting percentages can also make relative changes look large. A rise from 0.1% to 0.2% is only 0.1 percentage point, but it is a 100% relative increase. Both descriptions are mathematically correct, and including both may help readers understand the scale. Check that the input cells contain genuine percentage values rather than whole-number labels before interpreting either result.

Make results easier to read and maintain

Use column labels that identify both the metric and unit. “Difference” alone is less informative than “Change (percentage points),” while “Relative change (%)” makes clear that the result is calculated against a baseline. If you share the workbook, include a short note explaining which period is treated as the starting value.

For a table with many rows, keep the old and new percentages in separate, consistently labeled columns, put the calculation in its own column, and fill the formula down. Check a few rows manually, including a row where the value falls, to confirm that the sign and direction make sense. If the data contains blanks or zeros, decide how those cases should appear before using the results in a chart or summary.

For charts, make the axis and series labels clear. A chart of rate levels (such as 12% and 15%) is different from a chart of percentage-point changes (3 points) or relative changes (25%). Mixing those measures in one series without explicit labels can make comparisons misleading even when every formula is correct.

Frequently Asked Questions

What is the Excel formula to subtract two percentages?
Put the old percentage in A2 and the new percentage in B2, then use =B2-A2. The result is the point difference; format it as a percentage and describe it as percentage points.

How do I calculate percentage increase between two percentages in Excel?
With the old percentage in A2 and the new percentage in B2, use =(B2-A2)/A2 and format the result as a percentage. This reports relative change, provided the old value is not zero.

Is the difference between 10% and 15% 5% or 50%?
It is 5 percentage points by subtraction. It is a 50% relative increase if the value rose from 10% to 15%, because the 5-point rise is half of the original 10%.

Why does Excel show 300% instead of 3%?
The source cells may contain 12 and 15 as whole numbers instead of 12% and 15% as percentage values. Enter the values as 12% and 15%, or as 0.12 and 0.15, before subtracting and formatting the result.

Can I calculate percent change from zero?
No finite relative percent change can be calculated from a zero baseline because the formula would divide by zero. You can report the percentage-point difference, or explain the change using a different, well-defined baseline.

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.