In Excel, calculate percent change as (new value − old value) ÷ 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.
The percent change formula
Percent change measures how much a value moved relative to its starting value. The starting value is the old value, and the ending value is the new value. Subtract the old value from the new one to find the difference, then divide that difference by the old value. A positive result means an increase; a negative result means a decrease.
With the old value in B2 and the new value in C2, enter this in D2:
=(C2-B2)/B2
For example, if B2 contains 80 and C2 contains 100, the calculation is (100 − 80) ÷ 80, or 0.25. Formatted as a percentage, the result is 25%: the new value is 25% higher than the old value. The formula works with prices, counts, measurements, and other numeric values, as long as the old value is a meaningful, nonzero starting point.
You may also see the same calculation written as (new value ÷ old value) − 1. With the old value in B2 and the new value in C2, that equivalent formula is:
=C2/B2-1
Both versions return the same result. The subtraction-first version makes the change in the numerator more visible, which can make it easier to check the logic in a worksheet.
Format the result as a percentage
Excel stores percentages as decimal values: 0.25 represents 25%, and 1 represents 100%. The formula calculates the decimal result; number formatting displays it with a percent sign. Formatting does not change the underlying calculation.
To format the result in Excel for Microsoft 365 on Windows, select the result cell or range, then choose Home > Number > Percent Style. You can adjust the displayed decimal places with the increase or decrease decimal buttons in the Number group. On Mac, select the cells and use the percentage option in the Home tab’s number-format controls; the ribbon layout can differ slightly. In Excel for the web, select the cells and use the percentage format control on the Home tab.
Choose the number of decimal places that suits the data. A displayed result of 25% may be enough for rounded sales figures, while 25.37% can be useful when comparing precise rates. The stored value is still available for further calculations even if the cell displays fewer decimal places. Avoid multiplying the formula by 100 and also applying percentage formatting: doing both would turn a 25% result into a displayed 2,500%.
Work through a concrete example
Suppose a product cost $80 last month and costs $100 now. Put 80 in B2 and 100 in C2. With the old price in B2 and the new price in C2, enter this in D2:
=(C2-B2)/B2
D2 returns 0.25, which displays as 25% when formatted as a percentage. The price increased by $20, and $20 is one quarter of the original $80. This is a 25% increase, not a 20% increase: dividing the $20 difference by the new price of $100 answers a different question.
For a decrease, suppose a monthly bill falls from $100 to $80. With the old amount in B2 and the new amount in C2, use the same formula in D2:
=(C2-B2)/B2
The result is −0.20, or −20%. The negative sign indicates that the amount went down. You can describe this as a 20% decrease, or retain the minus sign when the direction of change matters in a report.
These examples show why the order of the two values matters. Reversing the old and new values changes both the direction and the reference amount. A movement from 80 to 100 is a 25% increase; a movement from 100 back to 80 is a 20% decrease. They describe the same two endpoints, but use different starting values.
Calculate percent change down a column
For a list of periods, keep the old and new values in separate columns and put the formula in a third column. For example, use column A for a label such as month, column B for the earlier value, column C for the later value, and column D for percent change. Put the first pair of values in row 2 and the next pair in row 3.
With each row’s old value in column B and new value in column C, enter this in D2:
=(C2-B2)/B2
After checking the first result, copy the formula down using the fill handle at the lower-right corner of the selected cell, or copy and paste it into the remaining rows. Excel adjusts the relative references in each row: the formula in D3 refers to B3 and C3. Apply percentage formatting to the entire result range for a consistent display.
Use clear column labels such as “Previous period,” “Current period,” and “Percent change.” Labels help prevent a common reporting error: treating the newer value as the baseline. If your data is arranged with dates in rows, check that each comparison uses the intended earlier and later periods, especially when the data is sorted newest first.
Handle a zero or missing starting value
The old value is the denominator, so the ordinary formula cannot calculate a meaningful percentage change when the old value is zero. In Excel, dividing by zero returns the #DIV/0! error. That error is not just a formatting issue: a change from zero to a positive number has no finite percentage increase relative to zero. Report the absolute change or describe it as starting from zero instead of assigning it a standard percent change.
If the old value is in B2 and the new value is in C2, and you want to show #N/A whenever the old value is zero, enter this in D2:
=IF(B2=0,NA(),(C2-B2)/B2)
This makes the zero-baseline case explicit while calculating normal rows as usual. A blank old-value cell is treated like zero in this comparison, so it also produces #N/A. If blanks should instead be handled differently—for example, if they mean “not reported”—decide on that rule and reflect it in a separate check before interpreting the result. Do not replace every error with zero automatically: zero percent change means “no movement,” which is not the same as “cannot calculate.”
Negative starting values can also make results counterintuitive. The arithmetic formula still returns a number, but a conventional percentage change may not communicate the comparison clearly when values cross zero or represent quantities that can be negative, such as profit or temperature relative to a chosen scale. In those cases, show the absolute difference alongside the percentage and explain the baseline.
Percent change versus percentage points
Percent change and percentage-point change are different measures. Percent change compares the difference with the old value. Percentage points simply subtract one percentage rate from another. Confusing them can make changes in rates sound much larger or smaller than they are.
For example, a rate that rises from 20% to 25% has increased by 5 percentage points. Its percent change is 25% because the five-point difference is one quarter of the starting rate of 20%. In a spreadsheet, if the old rate is in B2 and the new rate is in C2, enter the following in D2 to calculate percent change:
=(C2-B2)/B2
To calculate the percentage-point difference instead, with those same rates in B2 and C2, enter this in E2:
=C2-B2
Format E2 as a percentage if you want it to display as 5 percentage points (Excel will show 5%). Label the column clearly, because a cell formatted as a percentage does not tell readers whether it represents a relative percent change or a difference between rates. A note such as “percentage-point change” removes that ambiguity.
Common formula and interpretation mistakes
- Dividing by the new value: Use the old value as the denominator for percent change. In the move from 80 to 100, dividing 20 by 100 gives 20%, which is not the increase relative to the starting value.
- Swapping old and new: The formula is directional. Make sure the first input is the baseline and the second is the value being compared with it.
- Forgetting percentage formatting: A correct result may appear as 0.25. That is 25% in decimal form, not a failed calculation.
- Multiplying by 100 unnecessarily: Keep the formula as a decimal ratio when using Excel’s percentage format. Multiplying by 100 as well leads to a result one hundred times too large on display.
- Reading the sign as the size: A result of −20% means a decrease of 20%, not a negative amount of 20 units. The underlying values determine the unit change.
- Assuming two-way changes cancel: A 25% increase followed by a 25% decrease does not return to the starting value. Starting at 80, a 25% rise reaches 100; a 25% fall from 100 reaches 75, because the second change uses a different baseline.
When a result looks surprising, check the cell references, confirm which period is the baseline, and calculate the difference separately. For the 80-to-100 example, the difference is 20 and the baseline is 80; 20 divided by 80 is 0.25. This quick check can distinguish a formula error from an unexpected but mathematically correct result.
Frequently Asked Questions
What is the Excel formula for percentage increase?
Use (new value − old value) ÷ old value. 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.
How do I calculate percentage decrease in Excel?
Use the same formula, keeping the earlier, larger value as the old value and the later, smaller value as the new value. The answer will be negative; for instance, a change from 100 to 80 returns −20%, meaning a 20% decrease.
How do I calculate percent change if the original value is zero?
A conventional percent change is undefined because the formula divides by the original value. Show the absolute change, explain that the baseline was zero, or use a reporting rule that clearly marks the percentage as unavailable rather than treating it as 0%.
Why does Excel show 0.25 instead of 25%?
The calculation returns a decimal fraction. Select the result and choose Home > Number > Percent Style to display 0.25 as 25%. The underlying value remains 0.25.
Can I calculate percent change between two percentages?
Yes, if you want relative percent change, use the same formula with the old rate as the baseline. If you want the simple difference between rates, subtract them and describe the answer in percentage points. For a move from 20% to 25%, these answers are 25% relative change and 5 percentage points, respectively.
Related
- Password Protect Excel Before Opening: How It Works
- Outside Border Shortcut in Excel: Windows and Mac
- Excel Concatenation: Other Ways to Join Text Values
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Table Header Formula: What Works and What Doesn’tExcel table headers are column labels, not the place to put a formula you expect to calculate or…
- How to Find the Mode in Excel: Formulas and ExamplesTo find the most frequently occurring number in Excel, enter =MODE.SNGL(A2:A11) in an empty cell, replacing A2:A11 with…
- Alphabetize Names in Excel: Sort a List Step by StepTo alphabetize names in Excel, select the names and choose Data > Sort A to Z. If each…
- Excel Proper Case for Names: Formula and LimitsTo put names in proper case in Excel, use the PROPER function: with the original name in A2,…
- Excel MAX Function: Find the Highest Value in a RangeTo find the largest number in Excel, enter a formula such as =MAX(B2:B10) in an empty cell, replacing…
- Excel SUMIF Formula Examples for Everyday TasksExcel’s SUMIF function adds values that meet one condition. With regions in A2:A7 and sales amounts in B2:B7,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.