With the original value in B2 and the new value in C2, enter =(C2-B2)/B2 in D2 to calculate percent change; format D2 as a percentage. The result shows how much the value changed relative to its starting value, with increases positive and decreases negative.
How the Percent Change Formula Works
The calculation subtracts the original value from the new value, then divides that difference by the original value. In words, percent change equals (new value − original value) ÷ original value. Formatting the decimal result as a percentage expresses it on a scale readers can interpret easily.
For example, a change from 80 to 100 is a difference of 20. Dividing 20 by the original 80 gives 0.25, or a 25% increase. A change from 100 to 80 is −20 divided by 100, or −0.20, which Excel displays as a 20% decrease when the result is formatted as a percentage. The sign matters: positive means the new value is higher than the baseline, while negative means it is lower.
Excel stores percentages as decimal values. A displayed 25% is stored as 0.25, and a displayed −20% is stored as −0.20. The percentage format changes how a number appears; it does not change the underlying calculation. This is why the formula should not multiply by 100 if you plan to apply percentage formatting.
Enter the Formula in a Worksheet
Set up the sheet so each row contains a comparable pair of values: the original amount and the new amount. For example, B1 might be labeled Original, C1 New, and D1 Percent change. Put the first pair in row 2, then enter the calculation in D2. Keeping the baseline in a consistent column makes the formula easier to copy and audit.
- Enter the earlier or baseline value in B2 and the later value in C2.
- Select D2 and type
=(C2-B2)/B2. - Press Enter. If B2 is 80 and C2 is 100, the unformatted result is 0.25.
- With D2 selected, choose Home > Number > Percent Style to display 25%.
Excel for Microsoft 365 on Windows also offers the keyboard shortcut Ctrl+Shift+%. On a Mac, use Control+Shift+% if that shortcut is available with your keyboard layout; otherwise use Home > Number > Percent Style. You can increase or decrease displayed decimal places from the Number group. For many reports, one or two decimal places communicates useful precision without implying more certainty than the source data supports.
Worked Examples: Growth and Decline
For a sales comparison, suppose last month’s sales were $12,000 and this month’s were $15,000. With last month’s amount in B2 and this month’s amount in C2, enter =(C2-B2)/B2 in D2. The difference is $3,000, and $3,000 divided by $12,000 is 0.25, so the result is 25%. The dollar sign does not change the math; it is simply part of the way the values may be displayed.
For a decrease, suppose a product’s price falls from $50 to $40. With the old price in B2 and the new price in C2, enter =(C2-B2)/B2 in D2. The difference is −$10, and −$10 divided by $50 is −0.20, or −20%. The negative sign is a useful part of the result. If a report wants the wording “20% decrease” instead, retain the negative number for calculations and describe its meaning in a label or accompanying text.
For an unchanged value, such as 75 in both cells, the numerator is zero and the result is 0%. This distinguishes “no change” from a missing or unavailable comparison. When reporting a series, keep the order of the periods consistent: each new value should be compared with its own preceding baseline, not with a different period by accident.
Calculate Percent Change for Many Rows
For a list of comparisons, use the same column layout on every row. With original values in B2:B20 and new values in C2:C20, put the row formula in D2, using B2 and C2 as the first pair: =(C2-B2)/B2. After confirming the first result, copy D2 down the remaining rows with the fill handle, or copy and paste it. Excel adjusts the relative references as the formula moves, so the next row will refer to C3 and B3, then C4 and B4.
Check a few copied results against hand calculations, especially the first and last rows. A formula copied one row out of alignment can produce plausible-looking percentages while comparing the wrong records. If your data is in an Excel Table, entering the formula in the calculated column generally fills the formula down the column automatically. Give the column a clear heading such as Percent change, and keep source values in separate columns so reviewers can see the inputs behind each result.
Formatting and Rounding the Result
Use percentage formatting rather than typing a percent sign into the formula. With the result in D2, choose Home > Number > Percent Style. Excel displays 0.25 as 25%, not 0.25%. The default display may show no decimal places, so a small change can appear as 0% even when it is not exactly zero. Increase the number of displayed decimals when that distinction matters.
Formatting only changes what is shown. If a result is 0.256, displaying zero decimal places shows 26%, while one decimal place shows 25.6%; the underlying value remains 0.256. Avoid rounding the calculation unnecessarily if later formulas will use the result. For instance, rounding each row before calculating an average can produce a slightly different overall figure than averaging the full-precision results and rounding only the final display.
Sometimes a report needs a whole-number percentage as a separate value rather than just a whole-number display. With the original value in B2 and the new value in C2, use ROUND((C2-B2)/B2,2) in D2 to round the decimal result to two decimal places; then percentage-format D2. For the 80-to-100 example, the formula returns 0.25 and displays 25%. This kind of rounding is usually unnecessary for ordinary presentation, so prefer number formatting unless the rounded value itself must be used downstream.
Zero, Blank, and Negative Baselines
The original value is the denominator, so a baseline of zero makes the standard calculation undefined. A change from zero to 10 cannot be described as a finite percent increase using this formula: there is no nonzero starting amount against which to measure the difference. Excel will return a division-by-zero error. Do not label such a result as 100% or as an ordinary percentage increase; report the new value, or use a clearly defined alternative measure appropriate to the analysis.
If a zero baseline is possible and you prefer a readable marker, with the original value in B2 and the new value in C2, enter =IF(B2=0,"N/A",(C2-B2)/B2) in D2. This returns the text N/A when the original value is zero and otherwise calculates the change. Since the result column can now contain text as well as numbers, charts and later calculations may need special handling. Choose a marker such as N/A only if it suits the reporting convention.
Blank cells deserve attention too. A blank referenced in arithmetic can be treated like zero, potentially making an incomplete row look like a valid calculation. With the original value in B2 and the new value in C2, use =IF(OR(B2="",C2=""),"",IF(B2=0,"N/A",(C2-B2)/B2)) in D2 to leave the result empty when either input is blank and show N/A for a zero baseline. The formula does not verify whether the inputs are genuinely numeric; ensure the source data is clean and that text values have not been imported in place of numbers.
Negative baselines require judgment. The arithmetic formula still works, but percentage changes can be counterintuitive when comparing losses, debts, temperatures below zero, or other signed quantities. For example, moving from −10 to −5 makes the value numerically larger, yet the standard formula gives −50% because the difference of 5 is divided by −10. Explain the context and sign convention, or choose another measure if the usual percent-change interpretation would mislead readers.
Percent Change Versus Related Measures
Percent change is not the same as the absolute change. If a quantity rises from 80 to 100, the absolute change is 20 units and percent change is 25%. The absolute difference answers “How many units?”; percent change answers “How large was the difference compared with the starting amount?” A large percentage can result from a small absolute difference when the baseline is small, so reporting both can be helpful.
It is also different from percentage-point change. If a survey result moves from 40% to 50%, the increase is 10 percentage points. The relative percent change is 25%, because the 10-point increase is divided by the original 40%. These statements answer different questions and should not be swapped. For rates, shares, or margins, specify whether the comparison is in percentage points or percent change.
Percent change is directional and depends on which value is treated as original. A move from 80 to 100 is +25%, but reversing the comparison gives a −20% change, not −25%, because the denominator changes. This is normal, not a formula error. When comparing two groups without a natural earlier baseline, consider whether a symmetric comparison is more suitable and state the method used rather than calling every relative difference “percent change.”
Common Errors and How to Check Them
- Reversing the subtraction:
=(B2-C2)/B2flips the direction of the result. Use new minus original in the numerator. - Dividing by the new value: the baseline belongs in the denominator. Dividing by C2 answers a different question.
- Multiplying by 100 and applying percentage format: that displays a result 100 times too large. Use the decimal formula and format it as a percentage, or multiply by 100 only when you specifically want a plain numeric value such as 25.
- Comparing mismatched periods: confirm that each row’s original and new values refer to the same item and relevant time intervals.
- Ignoring missing or zero inputs: decide how to report unavailable comparisons before interpreting the results.
- Misreading the sign: a negative result usually means a decrease relative to a positive baseline; check unusual cases and the data’s sign convention.
A quick manual check can catch many mistakes: calculate the difference, divide by the original value, and compare the decimal with the displayed percentage. Also test a known unchanged pair and a simple increase, such as 100 to 110, which should produce 10%. If an expected result differs by a factor of 100, review whether the formula multiplied by 100 and whether the cell is percentage-formatted.
Frequently Asked Questions
What is the Excel formula for percent change? With the original value in B2 and the new value in C2, enter =(C2-B2)/B2. Format the result cell as a percentage to show the change relative to the original value.
How do I calculate percent increase in Excel? Use the same formula: with the starting value in B2 and the ending value in C2, enter =(C2-B2)/B2. If the ending value is higher, the formatted result is positive and represents the percent increase.
How do I calculate percent decrease in Excel? With the earlier, higher value in B2 and the later, lower value in C2, enter =(C2-B2)/B2. The result is negative; for example, moving from 100 to 80 gives −20%, indicating a 20% decrease.
Why does Excel show #DIV/0!? The original value used as the denominator is probably zero or blank. A zero baseline has no defined percent change under the standard formula. Check the input or use a deliberate N/A or blank-result rule rather than treating the error as a percentage.
Should I multiply the formula by 100? Usually, no. The formula returns a decimal proportion, and percentage formatting displays it as a percent. Multiplying by 100 as well as applying percentage formatting makes the displayed result 100 times too large.
Can I calculate percent change when the original value is zero? Not as a standard finite percent change: division by zero is undefined. Report the absolute change or use another explicitly explained measure that fits the situation.
Related
- Excel Data Validation Simple List: Create and Manage It
- Excel Data Validation List: Can It Show Two Columns?
- Excel Data Validation List With a Blank Option
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Capitalize Each Word in Excel with the PROPER FormulaTo capitalize the first letter of each word in Excel, enter =PROPER(A2) in an empty column beside the…
- Excel INDEX Function: Chinese Data, Syntax, and ExamplesIn Excel, INDEX returns a value from a specified position in a range, and it works with Chinese…
- Excel Filter for Specific Text: Steps and ExamplesTo filter Excel rows for specific text in Microsoft 365 on Windows, select a cell in your data,…
- Excel Formula for Finding Matches: A Practical GuideTo find the position of a value, use MATCH with exact-match mode. With the value to find in…
- Excel Min Date: Earliest Date and MIN FormulaIn Excel for Microsoft 365 on Windows, the earliest date Excel can store as a date in its…
- ISERROR in Excel: Check for Errors in Your FormulasIn Excel, use ISERROR to check whether a value or calculation produces an error: enter a formula such…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.