Excel Percent Change Formula and Examples

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 the old value is in B2 and the new value is in C2, enter =(C2-B2)/B2 in D2, then format D2 as a percentage. A positive result means an increase; a negative result means a decrease.

How the Percent Change Formula Works

Percent change measures how much a value has shifted relative to its starting value. The calculation has two parts: find the difference between the new and old values, then compare that difference with the old value. Dividing by the starting value is what makes the result relative rather than simply reporting the amount gained or lost.

With the old value in B2 and the new value in C2, the Excel formula is =(C2-B2)/B2. Excel evaluates the subtraction first, then divides by B2. For example, a move from 80 to 100 produces a difference of 20; 20 divided by 80 is 0.25, or a 25% increase.

Keep the order of the two values straight. Reversing the subtraction changes the sign and answers a different question. The old value belongs in the denominator because percent change describes the shift relative to where the measurement began—not relative to its ending value.

Enter the Formula and Show a Percentage

For a simple comparison, put the earlier or baseline value in B2 and the later value in C2. Select D2, type =(C2-B2)/B2, and press Enter. The result may initially appear as a decimal such as 0.25. That is the correct underlying result; it just needs percentage formatting to display as 25%.

In Excel for Microsoft 365 on Windows, select the result cell and choose Home > Number > Percent Style. You can use Increase Decimal in the same Number group if you want more digits, such as 25.00%. The same Home tab formatting controls are available in Excel for Microsoft 365 on Mac, although the ribbon layout can vary slightly with window size. Formatting changes how the value appears, not the calculation stored in the cell.

Excel’s percentage format displays the decimal multiplied by 100 and adds a percent sign. Therefore, a formula result of 0.25 displays as 25%. Do not multiply the formula by 100 and then apply percentage formatting: that would display 2,500%. If you need a percentage for a report, keep the formula as a decimal calculation and let the cell format handle the display.

Worked Examples: Increases and Decreases

For a price increase, assume the original price is in B2 and the new price is in C2. Enter =(C2-B2)/B2 in D2. If B2 is 80 and C2 is 100, the result is 0.25, which displays as 25% when D2 is formatted as a percentage. The price rose by 20, and that rise is one-quarter of the original 80.

For a decrease, use the same formula and keep the earlier amount in B2. If B2 is 100 and C2 is 85, =(C2-B2)/B2 returns -0.15, or -15%. The minus sign indicates a decrease of 15% from the starting amount. You do not need a separate formula for declines; the subtraction naturally produces a negative result when the new value is smaller.

For another useful check, compare a count that changes from 240 to 300. With the original count in B2 and the later count in C2, use =(C2-B2)/B2. The difference is 60, and 60 divided by 240 is 0.25, so the increase is 25%. Checking the arithmetic outside Excel is a practical way to catch swapped columns or an incorrect baseline.

Calculate Percent Change Down a Column

To compare many periods or records, use one row per comparison. Put the old values in column B and the corresponding new values in column C, starting on row 2. In D2, enter =(C2-B2)/B2. After checking that the first result is correct, fill the formula down through the remaining rows using the fill handle at the lower-right corner of D2.

Excel adjusts relative cell references as the formula is filled down: the next row will refer to B3 and C3, then B4 and C4, and so on. That is helpful when each row compares its own pair of values. Before copying, confirm that old and new values line up on the same row; comparing different products, months, or categories by mistake can produce plausible-looking but meaningless percentages.

If your starting row is different, change the row numbers accordingly. For example, if headings are in row 5 and the first data row is row 6, enter the calculation in D6 using B6 and C6. If you convert the data range to an Excel table, you can also use structured references, but ordinary cell references are often easiest to inspect and explain.

When the Old Value Is Zero

A zero starting value is the most important edge case. Percent change from zero is undefined under the standard calculation because the formula would divide by zero. If a quantity rises from zero to 10, it is reasonable to say that it increased by 10 units, but there is no finite percentage change relative to a starting amount of zero. Do not describe that as a 100% increase.

Excel will show a division-by-zero error if B2 is zero in the standard calculation. If you prefer to display a clear label in that case, with the old value in B2 and the new value in C2, enter =IF(B2=0,"N/A",(C2-B2)/B2). This returns the text N/A when the baseline is zero and calculates the percentage otherwise. Format the result column as a percentage; the text label remains text. Choose a label that suits your report, and make clear that zero-baseline cases are not comparable as standard percent changes.

A blank old-value cell is not the same thing as a meaningful zero. Check whether blanks represent missing data, values not yet recorded, or actual zeros before calculating. Treating missing data as zero can create an invalid comparison or a misleading result, especially in trend reports.

Percent Change Versus Other Comparisons

Percent change is often confused with percentage-point change. Suppose a rate moves from 20% to 25%. The difference is 5 percentage points, while the relative percent change is 25% because the increase of 5 is one-quarter of the starting rate of 20. Those are both valid descriptions, but they answer different questions. Use percentage points when comparing two percentages as simple rates; use percent change when you specifically want the relative change from the initial rate.

Percent change also differs from percent difference. Percent change has a defined direction: one value is the baseline and the other is the new measurement. Percent difference is commonly used when neither value is a natural starting point, and it uses a different denominator convention, often the average of the two values. For example, comparing measurements from two independent instruments may call for percent difference rather than treating one instrument’s reading as the original value. State which measure you use so readers can interpret it correctly.

For a straightforward amount gained or lost, subtracting the old value from the new value gives an absolute change, not a percentage. A change of 20 units could be large for a starting value of 40 and small for a starting value of 10,000. Percent change supplies that relative context, but the absolute change can still be useful alongside it.

Common Errors and Interpretation Tips

  • Using the wrong denominator: divide by the old value, not the new value. The new value is not the baseline in a standard percent-change calculation.
  • Reversing the inputs: make sure the earlier value is in the old-value cell and the later value is in the new-value cell. Reversing them can change both the sign and the percentage.
  • Multiplying by 100 twice: the calculation returns a decimal, and percentage formatting displays it as a percent. Do not add another multiplication by 100 when using Percent Style.
  • Ignoring a negative result: a negative percentage is not automatically an error. It usually indicates a decline, assuming the data and cell order are correct.
  • Comparing negative baselines without context: the arithmetic can be performed, but a conventional percentage interpretation may be confusing when values cross zero or the starting value is negative. Explain the chosen convention or report the absolute change instead.

Also check that both cells contain numeric values and use the same units and time basis. Comparing dollars with thousands of dollars, or a full-year figure with a one-month figure, can make the output misleading even when the formula itself is correct. If the underlying data has been rounded for display, the formula still uses the stored values, which may have more precision than the visible numbers.

Frequently Asked Questions

What is the Excel formula for percent change?
With the old value in B2 and the new value in C2, enter =(C2-B2)/B2 and format the result as a percentage. A positive result is an increase; a negative result is a decrease.

How do I calculate percentage increase in Excel?
With the original value in B2 and the increased value in C2, use =(C2-B2)/B2. Format the result as a percentage. For example, going from 80 to 100 returns 25%.

How do I calculate percentage decrease in Excel?
With the earlier value in B2 and the lower, later value in C2, enter =(C2-B2)/B2. A result of -15% means the value decreased by 15% from its starting point.

Why does my Excel percent change show as a decimal?
The formula returns a decimal fraction, such as 0.25. Select the result cell and choose Home > Number > Percent Style to display it as 25%. The underlying calculation does not change.

Can you calculate percent change from zero?
Not as a standard percentage: dividing by a zero baseline is undefined. Report the absolute change, or use a clear label such as N/A for that comparison rather than presenting a misleading percentage.

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.