Excel Formula for Percent Change: Examples and Tips

Formulas & functions · Updated November 19, 2026

To calculate percent change in Excel, subtract the old value from the new value, then divide by the old value. If A2 contains the old value and B2 the new value, enter =(B2-A2)/A2 and format the result as a percentage; a positive result means an increase and a negative result means a decrease.

What the percent-change formula measures

Percent change expresses the size and direction of a change relative to the starting value. It answers a question such as “How much higher is this month’s total than last month’s, as a share of last month’s total?” The starting value matters because it provides the reference point for the comparison.

The calculation has two stages: find the difference between the new and old values, then divide that difference by the old value. The result is a decimal ratio. Excel’s percentage number format displays that ratio as a percent: for example, 0.25 is displayed as 25%. The sign is meaningful: a positive result indicates growth, while a negative result indicates a decline.

This is a relative comparison, not simply the size of the difference. A change of 10 units is a 10% increase from 100, but a 100% increase from 10. The same absolute difference can therefore represent very different changes depending on the starting value.

Set up the cells in Excel

For a simple comparison, put the old value in one cell and the new value in another. A useful layout is to label the columns so that the order is unmistakable: “Old value” in A1, “New value” in B1, and “Percent change” in C1. Enter the first pair in row 2, then put the calculation in C2.

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

=(B2-A2)/A2

Use the new-minus-old order. Reversing the subtraction changes the sign and makes an increase look like a decrease. Also divide by the old value, not the new one: the old value is the baseline that defines the relative change.

For a list of comparisons, use one row per pair and copy the formula down. Excel adjusts the relative references automatically, so the next row will compare A3 with B3. If the data is arranged horizontally or the columns have different names, the same logic applies; change the cell references to match the locations of the old and new values.

Worked examples: increases and decreases

Suppose a product sold for $48 last month and $60 this month. With the old price in A2 and the new price in B2, the formula returns 0.25, or a 25% increase. The arithmetic is (60 − 48) ÷ 48 = 12 ÷ 48 = 0.25. The price rose by $12, which is one-quarter of its starting price.

Now consider a quantity that fell from 80 to 60. With 80 in A2 and 60 in B2, the formula returns −0.25, displayed as −25%. The arithmetic is (60 − 80) ÷ 80 = −20 ÷ 80 = −0.25. The negative sign signals a decline of 25% from the original quantity.

A decrease of 25% does not mean the value is now 25% of its original amount. In the second example, the new value is 75% of the old value: 60 is three-quarters of 80. This distinction is useful when explaining results in reports, especially when a percentage is presented without the underlying numbers.

Format the result as a percentage

Excel stores the result as a decimal ratio, so a correct calculation may initially appear as 0.25 rather than 25%. Select the result cell or range and choose Home > Number > Percent Style. The displayed value will be 25%. The same ribbon command is available in Excel for Microsoft 365 on Windows and Mac, although the ribbon layout can look slightly different depending on the window size.

Percent Style commonly displays no decimal places by default. If more precision matters, adjust the decimal places in the Number group on the Home tab. For example, a result of 0.256 can be shown as 25.6% instead of 26%. Keep enough precision for the purpose without implying a level of accuracy the source data does not support.

Formatting changes how a number appears, not the underlying value. Do not multiply the formula by 100 and also apply Percentage format, or a 25% result could display as 2,500%. If you need a numeric value for a chart or another calculation, leave the formula as a ratio and use number formatting to control its appearance.

Handle zero, blank, and negative starting values

If the old value is zero, the usual calculation divides by zero, and Excel returns a #DIV/0! error. This is not a calculation Excel can fix automatically: a percentage change from zero has no finite value under the standard definition because there is no nonzero baseline. A movement from zero to 5 is an increase of 5 units, but it is not a defined percent increase from zero.

For a report where you prefer a readable label instead of an error, you can use IFERROR. With the old value in A2 and the new value in B2, enter:

=IFERROR((B2-A2)/A2,"Undefined")

For a nonzero baseline, this returns the normal ratio; if the calculation produces an error, it displays “Undefined.” Because the result can now be either a number or text, apply Percentage format to the cell and verify that numeric cases still display as intended. If zero-baseline rows need special treatment, consider showing the absolute difference or a note rather than labeling them as a percentage.

A blank old-value cell may also be treated like zero in arithmetic and produce the same division error. Decide whether a blank means “no data” or genuinely zero, then handle it consistently. Negative starting values need care too. The standard formula can produce a sign that seems counterintuitive when values cross zero or move between losses and profits. Some analyses use the absolute value of the baseline instead, but that is a different convention and should be clearly labeled rather than silently substituted for the standard formula.

Calculate an overall change across multiple rows

When comparing totals across two periods, calculate the percent change from the total old value to the total new value. Do not automatically take the simple average of each row’s percentage change: that gives a small item the same influence as a large item and can misrepresent the overall movement.

With old values in A2:A10 and new values in B2:B10, use this formula to compare the two totals:

=(SUM(B2:B10)-SUM(A2:A10))/SUM(A2:A10)

For example, if the old values total 1,000 and the new values total 1,100, the result is 10%. This is equivalent to a weighted comparison in which larger starting values contribute more to the overall total. As with a single pair, the formula is undefined if the total old value is zero; check that the baseline is meaningful before interpreting the result.

There are situations where an average of row-level rates is appropriate—for example, when each observation should count equally regardless of its size. That answers a different question from the change in the combined total. Choose the method based on what the result is meant to describe, and state whether it is an average of rates or a rate calculated from totals.

Related calculations and common misunderstandings

Percent change is different from percentage-point change. If a measure rises from 20% to 25%, the change is 5 percentage points. Relative to its starting rate, however, the increase is 25%: (25% − 20%) ÷ 20% = 25%. These descriptions are both valid, but they answer different questions. Use “percentage points” for the direct subtraction of two percentages.

You can also use a known percentage change to calculate a future or adjusted value. With the starting value in A2 and the rate of change in B2, enter:

=A2*(1+B2)

If A2 is 80 and B2 is 15%, the result is 92 because 80 × 1.15 = 92. Enter a decrease as a negative rate: −15% produces 68. This calculation applies a rate to a starting value; it is not itself the formula for finding the percent change between two observed values.

Frequent mistakes include these:

  • Dividing by the new value instead of the old value, which changes the baseline.
  • Reversing the subtraction, which flips the direction of the result.
  • Multiplying by 100 and then applying Percentage format, which scales the displayed result twice.
  • Calling an undefined zero-baseline comparison “0%.” No change and an undefined percentage are not the same thing.
  • Comparing values from mismatched periods, units, or definitions. The formula can be mathematically correct even when the input comparison is not meaningful.

Frequently Asked Questions

How do I calculate percent change in Excel between two cells?

Put the old value in one cell and the new value in another, subtract old from new, and divide by old. For example, if the old value is in A2 and the new value is in B2, use =(B2-A2)/A2, then format the result as a percentage.

Why does Excel show a decimal instead of a percent?

The formula returns a decimal ratio, such as 0.25. Select the result and choose Home > Number > Percent Style to display it as 25%. Percentage formatting changes the display, not the calculation.

How do I calculate percent decrease in Excel?

Use the same formula as for an increase: (new value − old value) divided by old value. If the new value is lower, the result is negative. For example, a change from 80 to 60 returns −25%, indicating a 25% decrease.

What is the percent change from zero?

A standard percent change from a zero starting value is undefined because the calculation would divide by zero. Report the absolute difference, or explain the change in words, rather than presenting it as a defined percentage.

Is percent change the same as percentage-point change?

No. Percentage-point change is the direct difference between two percentages; moving from 20% to 25% is a 5-point increase. Percent change divides that difference by the starting percentage, making the relative increase 25%.

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.