Excel Formula for Percentage Increase: Examples and Tips

Formulas & functions · Updated November 18, 2026

To calculate percentage increase in Excel, subtract the old value from the new value, then divide by the old value. With the old value in A2 and the new value in B2, enter =(B2-A2)/A2; if A2 is 100 and B2 is 125, the result is 25% after you format it as a percentage.

How the percentage increase formula works

The calculation compares the amount of change with the starting value. First, the subtraction finds the difference between the new and old values. Dividing that difference by the old value expresses the change as a proportion of the starting point. Excel stores that proportion as a decimal: 0.25 represents 25%, and 0.08 represents 8%.

For example, if a monthly cost goes from $80 to $100, the change is $20. Dividing $20 by the original $80 gives 0.25, or a 25% increase. The old value belongs in the denominator because the question is how large the change is relative to where the measurement started.

With the old value in A2 and the new value in B2, use this formula in C2:

=(B2-A2)/A2

For A2 equal to 80 and B2 equal to 100, C2 evaluates to 0.25 before percentage formatting and displays as 25% afterward. The formula works for prices, counts, revenue, scores, and other numeric values, provided both inputs use compatible units and refer to comparable periods or cases.

Enter the formula and calculate a real example

Set up a simple worksheet with labels and values, for instance: A1 “Old value,” B1 “New value,” and C1 “Percentage change.” Put the starting amount in A2 and the later amount in B2. Select C2, enter the formula, and press Enter. For a concrete check, use 240 as the old value and 300 as the new value: the difference is 60, and 60 divided by 240 is 0.25, so the increase is 25%.

To calculate changes for several rows, keep the same layout for each record: old values in column A, new values in column B, and results in column C. Enter the formula in C2, then use the fill handle—the small square at the lower-right corner of the selected cell—to copy it down. Excel adjusts the relative references for each row, so the next row uses A3 and B3 rather than continuing to use A2 and B2.

Check that the two values in a row belong together. Comparing one product’s new price with another product’s old price can produce a valid calculation but a meaningless conclusion. A clear label for each row, such as product and month, helps make the comparison auditable.

Format the result as a percentage

The formula returns a decimal ratio, not a number already multiplied by 100. To show it as a familiar percentage, select the result cell or range and choose Home > Number > Percent Style in Excel for Microsoft 365 on Windows. Excel displays 0.25 as 25%. Applying percentage format changes how the value appears; it does not alter the underlying calculation.

For a quick Windows shortcut, select the cell and press Ctrl+Shift+%. This applies percentage formatting with no decimal places. On a Mac, the keyboard shortcut can depend on the keyboard layout, so use Home > Number > Percent Style if the shortcut is inconvenient. Excel for the web also has Percent Style on the Home tab.

If precision matters, increase the displayed decimal places with the Increase Decimal command in the Number group on the Home tab. A result of 0.256 may display as 26% with no decimal places or 25.6% with one decimal place. The stored value remains 0.256 in either case. Avoid typing a percent sign into the formula itself; formatting is easier to adjust and keeps the result numeric for later calculations.

Percentage increase versus percentage decrease

The same formula handles increases and decreases. If the new value is greater than the old value, the result is positive. If it is lower, the result is negative, which indicates a decrease. For example, a value falling from 100 to 80 changes by -20%, because the difference is -20 and the original value is 100. That negative sign is meaningful; it is not a formula error.

With the old value in A2 and the new value in B2, this version returns the absolute size of the change, without a negative sign:

=ABS((B2-A2)/A2)

For an old value of 100 and a new value of 80, this returns 20% rather than -20%. Use it only when you want the magnitude regardless of direction. For reporting, keeping the sign or adding a separate label for “increase” and “decrease” is usually clearer, because an absolute value alone does not say whether the measure rose or fell.

It is also possible to describe a decrease using a positive decrease rate, calculated as old value minus new value, divided by old value. State which convention you use when sharing results. A negative percentage change and a positive “percentage decrease” can describe the same movement, but they are not the same presentation.

What happens when the old value is zero?

A percentage change from zero is undefined: the calculation would divide by zero, and there is no meaningful finite percentage increase from a zero baseline. Excel reports a division-by-zero error if you use the ordinary formula with an old value of zero. This is a mathematical limitation, not something a different percentage format can fix.

If your report should show a text label instead of an error, with old values in A2 and new values in B2, use this formula in C2:

=IF(A2=0,"N/A",(B2-A2)/A2)

When A2 is zero, this displays N/A; otherwise, it calculates the percentage change. Because the formula can return either text or a number, results marked N/A will not behave like numeric percentages in every later calculation. Choose a label such as “N/A,” “New,” or a blank only if that wording fits the report, and explain how zero-baseline cases are treated.

A different issue occurs when the old value is negative, as can happen with profit or account balances. The formula still returns a number, but a percentage change across zero can be counterintuitive. For instance, moving from a loss of 10 to a profit of 10 produces a mathematical result of -200% under the standard calculation. That does not mean performance necessarily worsened; the conventional percentage-change interpretation is poorly suited to a negative starting point. Explain the underlying values or use a measure designed for that context.

Percentage change is not percentage-point change

Percentage change and percentage-point change answer different questions. Percentage change compares the difference with the starting value. Percentage points describe the direct subtraction of two rates or percentages. If a rate rises from 20% to 25%, it rises by 5 percentage points. Relative to the original 20% rate, however, the increase is 25%: the difference of five points divided by the original rate of 20% equals one quarter.

For percentage-point reporting, subtract the old rate from the new rate and format the result as a percentage. With the old rate in A2 and the new rate in B2, enter this in C2:

=B2-A2

If A2 contains 20% and B2 contains 25%, C2 displays 5% when formatted as a percentage. Describe that result as 5 percentage points, not a 5% relative increase. Use the percentage-increase formula when the intended question is how much the rate changed relative to its previous level.

Common mistakes and how to avoid them

  • Dividing by the new value: The denominator should be the old, starting value. Dividing by the new value answers a different question and gives the wrong percentage increase.
  • Multiplying by 100 and formatting as a percentage: A ratio of 0.25 becomes 25% through percentage formatting. If you multiply the formula result by 100 and then apply percent format, Excel displays 2,500%.
  • Reversing the subtraction: New minus old gives a positive result for an increase. Old minus new reverses the sign.
  • Comparing unlike data: Check units, time periods, currencies, and categories before comparing. A value in dollars cannot sensibly be compared with a value in thousands of dollars unless the units are first aligned.
  • Ignoring zero or negative baselines: Decide how to report these cases instead of hiding them with a blanket error-suppression formula. A zero baseline has no defined percentage change, and negative baselines need context.
  • Rounding too early: Keep the full underlying precision in the formula and adjust displayed decimal places for readability. Rounding source values before calculating can change the answer.

Also distinguish the actual cell value from its display. A cell showing 25% may contain 0.25, which is correct for this calculation. If another formula uses that cell, Excel uses the stored numeric value, not the visible characters.

Comparing several periods or groups

For a sequence of periods, calculate each adjacent change using the previous period as the old value. If monthly values are in B2:B13, put the first month-to-month result beside the second month, then fill the formula down for the remaining months. The first period has no earlier value in the sequence, so it cannot have a month-over-month change unless you supply a prior period.

Do not add separate monthly percentage changes to find the total change over several months. Rates compound because each period’s percentage is applied to a changing base. For example, a 10% rise followed by a 10% fall does not return to the starting value: 100 rises to 110, then falls by 11 to 99, for an overall decline of 1%.

To find the total change from the first value to the last, compare those endpoints directly. With the initial value in A2 and the final value in B2, use:

=(B2-A2)/A2

For example, an initial value of 100 and a final value of 99 gives -1%, even though the two intermediate rates were +10% and -10%. This endpoint method is appropriate for describing overall change across the full span; it does not replace period-by-period rates when you need to show the path taken.

Frequently Asked Questions

What is the Excel formula for percentage increase?
Subtract the old value from the new value, then divide by the old value. If the old value is in A2 and the new value is in B2, enter =(B2-A2)/A2 and format the result as a percentage.

How do I calculate percentage increase between two numbers?
Put the starting number in one cell and the later number in another, then use the formula with those cell references. For example, a change from 40 to 50 is 25%, because the increase of 10 is one quarter of the starting value, 40.

Why does Excel show 0.25 instead of 25%?
The formula returns a decimal ratio. Apply Percent Style from Home > Number > Percent Style to display 0.25 as 25%. Do not multiply by 100 if you are going to use percentage formatting.

Can the same formula calculate a percentage decrease?
Yes. If the new value is lower than the old value, the standard formula returns a negative percentage. A change from 100 to 80 returns -20%, indicating a 20% decrease.

How do I calculate a percentage increase when the old value is zero?
A standard percentage change is undefined when the old value is zero because it requires division by zero. Report the new value or use a clearly explained label such as N/A rather than presenting a fabricated percentage.

What is the difference between a 5% increase and a 5-percentage-point increase?
A 5% increase is relative to the starting value. A 5-percentage-point increase is a direct difference between two rates, such as a move from 20% to 25%. That move is five percentage points but a 25% relative increase.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.