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 A2 and the new value is in B2, enter =(B2-A2)/A2 in C2, then format C2 as a percentage; a positive result means an increase and a negative result means a decrease.
The Basic Percent-Change Formula
Percent change measures how much a value has changed relative to its starting value. The calculation is: (new value − old value) ÷ old value. Excel evaluates the subtraction first and then divides the difference by the starting value. The result is a decimal fraction: for example, 0.25 represents a 25% increase, while -0.25 represents a 25% decrease.
The old value is also called the original value, starting value, or baseline. The new value is the later or comparison value. The order matters: switching the two values changes both the reference point and usually the result. Percent change is not simply the difference between two numbers; it expresses that difference in relation to the starting value.
For example, a rise from 40 to 50 is a change of 10. Dividing 10 by the original 40 gives 0.25, or 25%. A rise from 400 to 410 is also a difference of 10, but it is only 2.5% of the original 400. That relative comparison is why percent change is useful when comparing changes across differently sized quantities.
Enter the Formula in Excel
For a simple two-value calculation, place the old value in A2 and the new value in B2. In C2, enter =(B2-A2)/A2. Press Enter to calculate the result. If the values are 80 in A2 and 100 in B2, the formula returns 0.25, which is a 25% increase once displayed as a percentage.
For a list, use the same arrangement in each row: old values in column A, new values in column B, and percent changes in column C. Enter the formula in C2, then use the fill handle—the small square at the lower-right corner of the selected cell—to copy it down. Excel adjusts the relative references for each row, so the next row uses A3 and B3, then A4 and B4, and so on.
To fill a formula down a selected range, select C2 and the cells below it, then press Ctrl+D in Excel for Windows. On a Mac, the equivalent is Control+D. You can also drag the fill handle down the column. Check a few copied rows to confirm the formula is using the old and new values on the same row.
Worked Examples: Increases and Decreases
Percent change works for both growth and decline. The sign of the result communicates the direction. In the following examples, the old value is in A2 and the new value is in B2; put the formula in C2 and apply percentage formatting.
- Increase from 80 to 100: The difference is 20, and 20 divided by 80 is 0.25. The result is 25% growth.
- Decrease from 120 to 90: The difference is -30, and -30 divided by 120 is -0.25. The result is -25%, meaning the value fell by 25% of its starting amount.
- Increase from 400 to 410: The difference is 10, and 10 divided by 400 is 0.025. The result is 2.5% growth, even though the absolute increase is the same as in a different-sized example.
- No change from 75 to 75: The difference is zero, so the result is 0%.
A negative result is not an error by itself. It is Excel’s normal way of showing a decrease when the starting value is positive. If a report requires the wording “25% decrease” rather than “-25%,” keep the numeric result and explain the sign in a label or accompanying text. Avoid changing the formula just to hide a meaningful negative sign.
Format the Result as a Percentage
Excel stores the result as a decimal fraction. A result of 0.25 is mathematically the same as 25%, but the decimal may be less readable in a report. Select the result cells and choose Home > Number > Percent Style. This displays 0.25 as 25% without changing the underlying value used in calculations.
Use the Increase Decimal or Decrease Decimal buttons in the Home tab’s Number group to control how many decimal places appear. For example, 0.025 may display as 3% when rounded to zero decimal places, or as 2.5% when shown to one decimal place. The stored result is still 0.025. Choose precision that suits the data, and retain enough decimals when small differences matter.
You can also right-click a selected cell and choose Format Cells, then select Percentage and set the number of decimal places. On Windows, Ctrl+1 opens Format Cells; on Mac, Command+1 opens the corresponding dialog. The Percent Style button and Format Cells options are available in current Excel for Microsoft 365 on both platforms, although ribbon placement can vary slightly with window size.
Choose the Right Comparison and Interpretation
Use percent change when you want to describe a value’s relative movement from a baseline. It commonly appears in month-over-month sales, year-over-year costs, website traffic, production volumes, and survey counts. The comparison is only meaningful when the two figures measure the same thing, use compatible units, and refer to clearly defined periods or populations.
For instance, comparing this month’s revenue with last month’s revenue gives a monthly change, while comparing it with the same month last year gives a year-over-year change. Those answers can differ because the baselines differ. State the comparison period in a chart heading or nearby label so readers know what the percentage refers to.
Percent change and percentage-point change answer different questions. If a rate rises from 10% to 12%, the increase is 2 percentage points. Relative to the old 10% rate, however, the percent change is 20%, because the two-point increase is one-fifth of the original rate. For rates, margins, and survey percentages, say which measure you mean rather than calling both simply “percent increase.”
Zero and Negative Starting Values
A starting value of zero makes the standard percent-change calculation undefined because it requires division by zero. If a count rises from zero to 12, the absolute increase is 12, but there is no finite percentage change relative to zero. Excel will show a division-by-zero error for the standard formula. Report the absolute difference, or explain that the percentage change is not defined, rather than presenting an invented percentage.
One way to prevent an error from appearing in a report is to leave the result blank whenever the old value is zero. If the old value is in A2, the new value is in B2, and the formula goes in C2, use =IF(A2=0,"",(B2-A2)/A2). This formula returns a blank for a zero baseline and calculates the ordinary change otherwise. A blank can be mistaken for missing data, so add a note or a separate status column if readers need to know why no percentage appears.
Negative starting values need care too. The arithmetic formula still returns a number, but conventional descriptions such as “growth” or “decline” may be confusing when the baseline is below zero. For example, moving from -10 to -5 is an increase in the numerical value, but the usual formula returns -50% because the denominator is negative. Explain the underlying values and direction, or use a clearly defined alternative measure if your field has one. Do not silently switch to an absolute-value denominator: that changes the convention and can change the interpretation.
Common Formula and Interpretation Mistakes
- Dividing by the new value: The denominator should be the old, starting value. Dividing by the new value gives a different statistic, not the standard percent change.
- Entering whole percentages as if they were raw amounts: If A2 contains 10% and B2 contains 12%, Excel stores these as 0.10 and 0.12, and the standard calculation gives 20%. If you enter 10 and 12 instead, the result is still 20%, but those cells now represent plain numbers rather than percentage rates. Keep the units consistent.
- Typing a percent sign into the formula unnecessarily: The calculation already returns a fraction. Format the cell as a percentage instead of multiplying by 100 and then applying percentage formatting, which would display a result 100 times too large.
- Comparing unlike periods or categories: A percentage can be calculated even when the underlying figures are not comparable. Check units, date ranges, and definitions before interpreting the result.
- Rounding too early: Display formatting changes what readers see, not the stored precision. Avoid replacing formulas with rounded values unless rounding is specifically required for the analysis.
Percent Change Versus Other Excel Calculations
Percent change is not the same as percentage of a total. To find what share one value represents of another, divide the part by the whole. For example, if completed tasks are 18 and total tasks are 24, the completion share is 75%. That answers “what portion of the total?” rather than “how much did the value change from before?”
It is also different from a simple numerical difference. If a price moves from 25 to 30, the absolute difference is 5 units and the percent change is 20%. Both facts may be useful: the difference communicates the amount, while the percentage gives the amount in relation to the starting value.
Sequential percentage changes do not generally add together. A 10% increase followed by a 10% decrease does not return to the starting value: starting at 100, the increase produces 110, and a 10% decrease from 110 produces 99. The net change is -1%, not zero. When comparing periods across a sequence, calculate the overall change from the first value to the final value if that is the question being asked.
Frequently Asked Questions
What is the Excel formula for percent change?
If the old value is in A2 and the new value is in B2, enter =(B2-A2)/A2. Format the result cell as a percentage. The formula uses the old value as the baseline.
How do I calculate percent decrease in Excel?
Use the same formula as for an increase. With the old value in A2 and the new value in B2, =(B2-A2)/A2 returns a negative percentage when the new value is lower. For example, a fall from 120 to 90 returns -25%.
Why does Excel show a decimal instead of a percent?
The calculation returns a decimal fraction, such as 0.25 for 25%. Select the result and choose Home > Number > Percent Style to display it as a percentage.
How do I calculate percent change when the old value is zero?
The standard formula cannot calculate a finite percentage because it would divide by zero. Report the absolute change, identify the percentage as undefined, or use a blank or explanatory label in the result column.
Is percent change the same as percentage-point change?
No. A rate rising from 10% to 12% increases by 2 percentage points, while its relative percent change is 20%. Use the term that matches the comparison you intend to communicate.
Related
- Excel Conditional Formatting With Dates: A Practical Guide
- Excel Conditional Formatting for Date Ranges Explained
- Excel Conditional Formatting for Upcoming Dates
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Amortization Schedule Excel Formula: Build It Step by StepTo calculate a fixed monthly loan payment in Excel, put the principal in B1, the annual interest rate…
- Simple Gradebook Spreadsheet: Setup, Formulas, and TipsA simple gradebook spreadsheet can track students, assignment scores, and current averages in Microsoft Excel. With a student…
- Excel Formula for Years Between Dates: Exact or DecimalFor completed years between two dates in Microsoft Excel, enter a start date in A2 and an end…
- HLOOKUP in Excel With Multiple Criteria: A Clear GuideHLOOKUP does not accept separate criteria on its own, but you can make it work by combining the…
- Excel Formula to Count Cells With Text in Any RangeTo count cells containing text in Excel, use =COUNTIF(A2:A100,"*"), replacing A2:A100 with your range. The asterisk is a…
- How to Copy Formula Data in Excel Without Breaking ReferencesTo copy formula data in Excel, select the cells, press Ctrl+C, choose the destination, and use Home >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.