Percentage Change Calculator Formula in Excel: Examples

Formulas & functions · Updated November 20, 2026

To calculate percentage change in Excel, subtract the old value from the new value, then divide by the old value: =(B2-A2)/A2. With the old value in A2 and the new value in B2, format the result as a percentage to see the increase or decrease.

The percentage change formula

Percentage change measures how much a value changed relative to where it started. The general calculation is (new value − old value) ÷ old value. Excel uses the result as a decimal: a result of 0.25 means a 25% increase, while -0.2 means a 20% decrease.

For a worksheet with the starting value in A2 and the ending value in B2, enter =(B2-A2)/A2 in C2. This is the standard percentage change formula when the starting value is not zero. It works for prices, sales, website visits, quantities, test scores, and many other measurements, provided the two values use the same units and refer to comparable periods or items.

The order matters. The old value is the denominator because it is the reference point. Dividing by the new value instead answers a different question and will generally produce a different percentage. Likewise, entering =(A2-B2)/A2 reverses the sign, so an increase would appear as a decrease.

How the calculation works

Suppose a product’s price rises from $80 to $100. The difference is $20, and $20 divided by the original $80 is 0.25, or 25%. In a worksheet where A2 contains 80 and B2 contains 100, =(B2-A2)/A2 returns 25% after percentage formatting.

If the price instead falls from $100 to $80, the difference is -$20. Dividing by the original $100 gives -0.2, displayed as -20%. A negative result is not an error: it identifies a decrease. The sign tells you the direction, while the size of the number tells you the relative amount of change.

Percentage change is not the same as the absolute difference. A $20 rise is the same dollar difference in both examples, but it represents 25% of $80 and 20% of $100. Always interpret the percentage alongside the starting value when the underlying scale matters.

Enter and format the formula in Excel

  1. Put the earlier or starting value in A2 and the later or ending value in B2. Add clear headings such as “Old value” and “New value” so the column order is unambiguous.
  2. In C2, enter =(B2-A2)/A2, assuming A2 is the old value and B2 is the new value.
  3. Select C2, then choose Home > Number > Percent Style (%) to display the decimal as a percentage.
  4. Use Increase Decimal or Decrease Decimal in the Home tab’s Number group to choose how many decimal places to show. For example, 0.253 becomes 25.3% with one decimal place or 25% with none.
  5. For more rows, drag the fill handle at the lower-right corner of C2 down the column, or copy and paste the formula into the required cells. Excel adjusts the relative row references automatically.

Formatting changes how a result is displayed, not the underlying calculation. A value stored as 0.25 can display as 25%, 25.0%, or 0.25 depending on its number format. If you multiply the formula by 100 and also apply percentage formatting, the result will be 2,500%, because percentage formatting already displays a decimal as a percentage.

Worked examples for increases and decreases

Here are several examples using the same formula. Each old value belongs in A2 and each new value in B2; enter =(B2-A2)/A2 in C2 and apply Percentage format.

Old value New value Change Meaning
80 100 25% Increase of one quarter of the starting value
100 80 -20% Decrease equal to one fifth of the starting value
240 300 25% Increase of 60 relative to 240
50 45 -10% Decrease of 5 relative to 50

For a practical example, imagine monthly sales increased from 12,000 units in January to 13,800 in February. The difference is 1,800 units; relative to January, that is 15%. If the values are in A2 and B2, the formula returns 0.15, which displays as 15%. Be careful to compare like with like: a partial month compared with a complete month may show a change that reflects different reporting periods rather than a genuine trend.

Handle zero, blank, or negative starting values

A starting value of zero makes the standard formula undefined because it would divide by zero. Excel will display a #DIV/0! error. There is no finite percentage change from zero under the usual definition: moving from zero to 10 is an increase of 10 units, but it cannot be expressed as a percentage of zero. In reporting, show the absolute change, label the percentage as not applicable, or explain the chosen convention rather than presenting a misleading percentage.

To leave the result blank when either input is missing or the old value is zero, use this formula in C2, assuming A2 holds the old value and B2 the new value: =IF(OR(A2="",B2="",A2=0),"",(B2-A2)/A2). The formula returns a blank for those cases and calculates the percentage otherwise. This can make a report easier to read, but it also hides why a percentage is absent; consider adding a note or a separate status column if users need to distinguish missing data from a zero baseline.

Negative starting values need care too. The standard formula is mathematically computable, but a negative denominator can make the sign hard to interpret in ordinary business language. For example, moving from -10 to -5 returns -50% using the standard formula, even though the value moved upward toward zero. If values can be negative, explain your convention and consider reporting the absolute change as well. Percentage change conventions for values that cross or approach zero may differ by field, so do not assume the result has an intuitive meaning.

Common formula and formatting problems

  • Wrong reference order: Check that the old value is the denominator and the new value is first in the subtraction. Reversing the inputs changes the meaning and often the sign.
  • Unexpected decimal result: A result such as 0.08 is 8% when formatted as Percentage. It is not necessary to multiply by 100 before applying that format.
  • #DIV/0! error: Check whether the starting cell contains zero or is being treated as zero. Decide whether to report the absolute difference, leave the percentage blank, or show an explanatory label.
  • Formula copied to the wrong rows: Relative references normally adjust when copied down. Confirm that each row is comparing its own old and new values, not a neighboring row.
  • Numbers stored as text: Imported values may look numeric but be stored as text, preventing normal arithmetic. Check the cell contents and convert the values to numbers before relying on the result.
  • Misleading comparison: Make sure both values represent the same measure, unit, time span, and scope. Comparing revenue in dollars with revenue in thousands, for example, produces a meaningless percentage.

Percentage change versus percentage points

Percentage change compares one value with its earlier level. Percentage points describe the arithmetic difference between two percentages. Confusing them can make a report sound as though a change were much larger or smaller than it was.

For example, a rate that moves from 10% to 12% has risen by 2 percentage points. Its relative percentage change is 20%, because the two-point increase is one fifth of the original 10% rate. If A2 contains 10% and B2 contains 12%, the standard formula =(B2-A2)/A2 returns 20%. To state the direct difference in percentage points, subtract the two rates: B2 minus A2 equals 2 percentage points. Keep the labels explicit in charts and written summaries.

Also distinguish percentage change from percentage difference. Percentage change has a designated starting value, so it uses that value as the reference. Percentage difference is sometimes used when neither value is considered the baseline; different fields may define its denominator differently. If you are comparing two measurements without a natural “before” and “after,” state the method instead of calling every relative comparison percentage change.

Calculate changes across a full list

For a time series, put dates in column A and measurements in column B, with the first measurement on row 2. Starting with the second measurement, compare each row with the row immediately above it. In C3, enter =(B3-B2)/B2, assuming B2 is the previous period and B3 is the current period. Format C3 as a percentage and fill it down. The first row has no prior period in the table, so it has no row-to-row percentage change to calculate.

This method is useful for month-over-month or year-over-year comparisons, but the comparison period should be chosen deliberately. Month-over-month results may be affected by seasonality, while year-over-year results can be easier to compare for seasonal businesses. Excel calculates the arithmetic; it cannot determine whether the selected periods make the comparison meaningful.

Frequently Asked Questions

What is the Excel formula for percentage increase?
With the old value in A2 and the new value in B2, enter =(B2-A2)/A2 and format the result as a percentage. A positive result indicates an increase.

How do I calculate percentage decrease in Excel?
Use the same formula: with the old value in A2 and the new value in B2, enter =(B2-A2)/A2. If B2 is lower than A2, the result is negative; for example, a change from 100 to 80 displays as -20%.

Why does my percentage change formula show #DIV/0!?
The old-value cell is probably zero or blank and is being treated as zero. Percentage change from a zero baseline is undefined. Report the absolute difference or use a formula that leaves the percentage blank for zero or missing inputs.

Do I multiply the percentage change formula by 100?
No, not if you format the result as a percentage. Excel converts a decimal such as 0.15 to 15% for display. Multiplying by 100 and then applying Percentage format would display 1,500%.

How do I calculate percentage change when the values are in different rows?
Reference the cells containing the old and new values, regardless of their positions. For example, if the old value is in B2 and the new value is in B3, enter =(B3-B2)/B2 in the result cell and apply Percentage format.

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.