Excel Percentage Change Formula: Examples and Common Errors

Formulas & functions · Updated November 19, 2026

To calculate percentage change in Excel, subtract the old value from the new value, divide by the old value, and format the result as a percentage. If the old value is in B2 and the new value is in C2, enter =(C2-B2)/B2 in D2; for example, a change from 120 to 150 returns 25%.

What Percentage Change Measures

Percentage change describes how much a value has risen or fallen relative to its starting value. It expresses the difference as a fraction of the old value, making changes easier to compare across quantities with different scales. A rise of 10 units is substantial if a value started at 20, but small if it started at 1,000; percentage change gives those changes context.

The result has a sign as well as a size. A positive result means the new value is higher than the old one, while a negative result means it is lower. A result of 0% means there was no change. The calculation is commonly used for sales, prices, attendance, monthly expenses, and other measurements that have a meaningful starting value.

The Basic Excel Formula

With the old value in B2, the new value in C2, and the result intended for D2, enter =(C2-B2)/B2. Excel first calculates the difference, C2 minus B2, then divides that difference by B2. The parentheses make the order clear, even though Excel would also evaluate the subtraction before the division here.

For example, if B2 contains 120 and C2 contains 150, the difference is 30, and 30 divided by 120 is 0.25. Excel stores that result as a decimal; displaying it as a percentage shows 25%. If the old value is 150 and the new value is 120, the difference is -30, and -30 divided by 150 is -0.20, or -20%.

Keep the old value as the denominator. Dividing by the new value instead answers a different question and gives a different result. For a percentage change, the reference point is the value before the change.

Enter the Formula and Fill It Down

For a list of before-and-after values, put the old values in column B, the new values in column C, and the percentage changes in column D. With the first pair on row 2, enter =(C2-B2)/B2 in D2. Check that the row references match the values on that row before copying the formula.

To calculate additional rows, select D2 and drag the small fill handle at the lower-right corner of the cell down the column. You can also copy D2, select the cells below it, and paste. Excel adjusts the relative references for each row: the next row uses B3 and C3, then B4 and C4, and so on. If the result is not a percentage yet, apply percentage formatting after filling.

For instance, if B2:C4 contain 120 and 150, 80 and 60, and 40 and 44, respectively, the results are 25%, -25%, and 10%. Each row is compared with its own old value, so a single formula can be copied down a consistent dataset.

Format the Result as a Percentage

Excel calculations store percentages as decimal values: 0.25 represents 25%, and -0.2 represents -20%. To display a result in the familiar percentage format, select the result cell or range and choose Home > Number > Percent Style. The same ribbon path is available in Excel for Microsoft 365 on Windows and Mac, although the ribbon layout can vary slightly by window size.

Excel’s Percentage format commonly displays two decimal places by default, but you can adjust the displayed precision with the Increase Decimal or Decrease Decimal controls in the Home tab’s Number group. For whole-number changes, showing no decimal places may be easier to read; for small changes, one or more decimal places may be useful. Formatting changes how the value appears, not the underlying calculation.

Do not multiply the formula by 100 and then apply Percentage format. With the stated layout, the formula =(C2-B2)/B2 already returns a decimal that Percentage format scales for display. Multiplying by 100 as well would make a 25% result display as 2,500%.

Reading Increases, Decreases, and Percentage Points

A positive result is an increase and a negative result is a decrease. The sign is useful, but interpret the size in relation to the starting value. A move from 100 to 110 is a 10% increase; a move from 110 back to 100 is not a 10% decrease. The return is about -9.09%, because the decrease of 10 is measured against 110.

Percentage change is also different from a percentage-point difference. If a rate moves from 20% to 25%, it has risen by 5 percentage points. Its relative percentage change is 25%, because the five-point increase is one quarter of the original 20% rate. Which description is appropriate depends on the question: compare rates in percentage points when discussing the absolute gap between them, and use percentage change when describing the relative movement.

Excel treats percentage values as numbers for this calculation. With the old rate in B2 and the new rate in C2, enter =(C2-B2)/B2 in D2 to find the relative change. If B2 is 20% and C2 is 25%, D2 displays 25% when formatted as a percentage. Subtracting the two rates directly would instead give a difference of 5 percentage points.

Zero, Blank, and Negative Starting Values

A zero old value makes the standard calculation undefined because it would require division by zero. In Excel, the basic formula returns the #DIV/0! error when B2 is zero. There is no single percentage-change value that correctly describes a change from zero using the usual definition: a move from zero to five has no nonzero starting amount against which to measure the increase. Report the absolute change, use a clearly defined alternative measure, or label the percentage change as not applicable rather than presenting a misleading number.

Blank starting or ending cells need attention too. In arithmetic, a blank cell reference can behave like zero, so an empty old-value cell may trigger the divide-by-zero error, while an empty new-value cell may be treated as zero and appear to show a full decline. Before interpreting results, verify that both cells contain the intended numeric observations. If blank means “not recorded” rather than zero, do not let it stand in for a real measurement.

Negative values require judgment about what the result means. The formula can calculate a numerical result when the old value is negative, but calling that result an increase or decrease may not match the subject. For example, moving from a loss of 100 to a loss of 50 is an improvement in ordinary business language, even though the standard formula divides by a negative starting value. When values can cross zero or represent losses, debts, temperatures, or other signed quantities, explain the calculation and consider whether absolute change is clearer.

Common Errors and How to Check Them

  • Using the wrong denominator: Divide by the old value, not the new value. Confirm which column represents the starting point.
  • Reversing the subtraction: New minus old gives the expected sign for change. Old minus new flips positive increases into negative results.
  • Multiplying by 100 unnecessarily: Use the decimal result and apply Percentage format. Otherwise the displayed percentage is 100 times too large.
  • Comparing different periods or units: Check that each old and new value refers to the intended periods and uses the same units.
  • Ignoring errors or missing data: Investigate zero denominators, empty cells, and nonnumeric entries instead of hiding them without explanation.

When a result looks surprising, inspect the underlying decimal by temporarily applying General format, then check the input cells and calculation direction. For a known example such as 120 changing to 150, the displayed result should be 25%. A result of 20% suggests the new value may have been used as the denominator; a result of 2,500% suggests the formula may have been multiplied by 100 before percentage formatting.

Comparing Several Changes

When each row represents a separate item or period, calculate each row’s percentage change and then decide what summary is meaningful. A simple average of row-level percentage changes gives every row equal weight, whether its starting value is large or small. That may be appropriate when each item matters equally, but it is not always the overall percentage change for the group.

To find the total change across a set, compare the sum of the new values with the sum of the old values. With old values in B2:B4 and new values in C2:C4, enter =(SUM(C2:C4)-SUM(B2:B4))/SUM(B2:B4) in D2. If the old values are 100, 300, and 600, and the new values are 110, 330, and 660, the total rises from 1,000 to 1,100, so the result is 10%. In this example each row rises by 10%, so the simple average agrees with the total change; with different row changes, the two summaries can differ.

This aggregate calculation still requires a nonzero total starting value and comparable units. It answers “How much did the combined total change relative to its starting total?” It does not answer “What was the average percentage change of a typical row?” State which question your summary is meant to answer.

Frequently Asked Questions

What is the formula for percentage change in Excel?
With the old value in B2 and the new value in C2, enter =(C2-B2)/B2 in the result cell, then format that cell as a percentage. The result is the change relative to the old value.

How do I calculate percentage decrease in Excel?
Use the same formula as for an increase. With the old value in B2 and the new value in C2, enter =(C2-B2)/B2. A lower new value produces a negative result, which indicates a decrease. For example, 80 falling to 60 gives -25%.

Why does my percentage change formula show #DIV/0!?
The old value used as the denominator is probably zero or blank. Percentage change from a zero baseline is undefined under the usual formula. Check whether the starting value is missing or genuinely zero, then report an appropriate alternative instead of treating the error as a valid percentage.

Do I multiply the percentage-change formula by 100?
No, not if you format the result as a percentage. The formula returns a decimal, and Percentage format displays that decimal as a percentage. Multiplying by 100 as well makes the displayed result 100 times too large.

How do I calculate percentage change between two percentages?
Use the same relative-change formula when you want the percentage movement relative to the original rate. For a change from 20% to 25%, that is a 25% relative increase. The direct difference is 5 percentage points, which is a separate way to describe the change.

Can percentage change be negative?
Yes. A negative result means the new value is below the old value, provided the old value is positive and the usual interpretation fits the data. For negative starting values or measurements that cross zero, explain the context because the sign can be easy to misread.

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.