How to Calculate Percentage Change in Excel: 3 Easy Ways in 2026

To calculate percentage change in Excel, subtract the old value from the new value and divide by the old value. For example, type =(C2-B2)/B2 in a blank cell. Then select Percent Style on the Home tab to show the result as a percentage.
This guide covers three ways to calculate percentage change: a single formula, a formula filled down a whole column, and a PivotTable setting. It also covers zeros, negative numbers, and common errors, plus a faster way to report changes from large files. Steps come from Microsoft's support pages, read on November 13, 2026.
What percentage change means
Percentage change shows how much a value went up or down, relative to where it started. It answers questions such as "How much did sales grow this month?"
The formula is the same everywhere:
Percentage change = (new value − old value) ÷ old value
Microsoft's support page describes it this way. You calculate the change "by subtracting your new earnings from your original earnings, and then dividing the result by your original earnings." In practice, the new value comes first in the subtraction, so growth shows as a positive number.
A positive result means an increase. A negative result means a decrease. A result of 0 means no change. The size of the base matters too. The same 500-unit rise is a 50% increase from 1,000 but only a 5% increase from 10,000. That is why the old value always sets the scale.
Microsoft's own example uses monthly earnings. Earnings are $2,342 in November and $2,500 in December. The formula =(2500-2342)/2342 returns 0.06746. Formatted as a percentage, that is a 6.75% increase.
The same page shows a decrease. If January earnings are $2,425, the formula =(2425-2500)/2500 returns -0.03. That is a 3% decrease from December.
Percentage change vs. percentage difference vs. percentage points
These three terms are often mixed up. They answer different questions.
| Term | What it measures | Example |
|---|---|---|
| Percentage change | Change from an old value to a new one | Sales rose from 100 to 120, a 20% increase |
| Percentage difference | Gap between two values with no "before" and "after" | Store A sells 100, Store B sells 120 |
| Percentage points | Change between two percentages | A margin moves from 10% to 12%, up 2 percentage points |
Use percentage change when there is a clear starting point, such as last month or last year. Use percentage points when both values are already percentages. A margin that moves from 10% to 12% is up 2 percentage points, but up 20% in relative terms.
Saying which one you mean avoids confusion in reports. "Up 2 points" and "up 20%" describe the same margin move, but they sound very different.
Set up your data first
Percentage change formulas are simple, but the layout makes them easier to fill and check.
A clean layout looks like this:
- One row per item or period. For example, one row per month or one row per product.
- Old and new values in side-by-side columns. For example, last year in column B and this year in column C.
- Numbers stored as numbers. Values with text, such as "1,200 units," will not calculate.
- A header row. Clear labels such as "2025" and "2026" help when you read the result.
For a time series, such as monthly sales, keep one value column in date order. Each month's change then compares with the row above it.
Check for blanks and zeros before you start. A zero in the old value causes an error, which is covered later in this guide.
Way 1: Calculate percentage change with a formula
This is the standard method. It works in every version of Excel.
Microsoft's format page gives the cell version of the formula. If B2 holds November earnings and C2 holds December earnings, you enter =(C2-B2)/(B2) in D2. Microsoft says this formula "divides the difference between the second and first numbers by the value of the first number."
Follow these steps:
- Select the cell where you want the result, such as D2.
- Type =(C2-B2)/B2 and press Enter.
- Select the cell, and on the Home tab, select Percent Style.
Microsoft notes a keyboard shortcut for the last step. You can "click Percent Style in the Number group on the Home tab, or press Ctrl+Shift+%."
The parentheses matter. Without them, Excel divides B2 by B2 first and then subtracts, which gives the wrong answer. Always wrap the subtraction in parentheses.
To show more or fewer decimal places, use Increase Decimal or Decrease Decimal on the Home tab. One decimal place, such as 6.7%, is enough for most reports.
Way 2: Calculate change for a whole column
Most real work involves many rows. You write the formula once and fill it down.
For two columns, such as last year and this year:
- Type =(C2-B2)/B2 in D2.
- Select D2, then double-click the fill handle in the corner of the cell.
- Excel copies the formula down to the last row of data.
- Apply Percent Style to the whole column.
For a single column of values in date order:
- Put the values in column B, starting in B2.
- In C3, type =(B3-B2)/B2. The first period has no earlier value, so C2 stays blank.
- Fill the formula down to the last row.
For change from a fixed starting point:
Sometimes you want every month compared with January, not with the month before. Use an absolute reference, so the base cell does not move as you fill.
- In C2, type =(B2-$B$2)/$B$2.
- Fill the formula down.
The dollar signs lock the reference to B2. Each row now shows growth since January. This is useful for charts that show cumulative growth from a launch date.
Way 3: Use % Difference From in a PivotTable
If your data is already in a PivotTable, you do not need a formula. A built-in option shows each value as a percentage change.
Microsoft describes the option this way. % Difference From "Displays values as the percentage difference from the value of the Base item in the Base field."
Follow Microsoft's steps:
- In the PivotTable, right-click the value field, and then click Show Values As.
- Choose % Difference From. Select More Options on the menu if you don't see it listed.
Then choose the Base field, such as Month, and the Base item. In the base item list, (previous) compares each item with the one before it.
With (previous) as the base item, each month is compared with the month before. With a fixed item, such as January, each month is compared with January.
Mac users have a small difference. Microsoft notes that in Excel for Mac, the menu "doesn't list all the same options as Excel for Windows, but they are available."
To see the original values next to the change, add the same field to Values twice. Keep one as a sum and set the other to % Difference From. Our guide on how to make a pivot table in Excel covers PivotTable basics.
Handle zeros, negatives, and errors
A few cases break the simple formula. Plan for them before you share a report.
Zero in the old value. Dividing by zero returns #DIV/0!. Wrap the formula in IFERROR to show a blank or a note instead:
=IFERROR((C2-B2)/B2, "")
Be honest in the report about what the blank means. Growth from zero has no meaningful percentage, so "new" is often a better label.
Negative old values. If the old value is negative, such as a loss, the sign of the result can mislead. A loss shrinking from -100 to -50 gives -50%, even though results improved. Some analysts divide by the absolute value, =(C2-B2)/ABS(B2), to keep the direction right. State the method in a footnote when you do this.
Text instead of numbers. Cells that look like numbers but are stored as text return #VALUE!. Convert them to numbers first.
Very small bases. A change from 2 to 10 is a 400% increase. It is correct, but it can overstate a tiny change. Show the raw numbers alongside the percentage.
Show percentage change clearly in a report
A column of percentages is hard to scan. A few formatting choices make the changes easy to read.
Use color for direction. Conditional formatting can turn increases green and decreases red. Select the change column, then use Conditional Formatting on the Home tab. Microsoft's format page links to its guide on conditional formats.
Add a sign to increases. A custom number format such as +0.0%;-0.0%;0.0% shows a plus sign on growth. Readers then see the direction without relying on color alone.
Keep the raw numbers nearby. A change of 50% means little without the values behind it. Put the old and new values in the columns next to the change.
Round consistently. Pick one decimal place for the whole report. Mixing 12.5% and 12.53% in the same table looks careless.
Chart the change, not only the values. A column chart of monthly change shows which months rose and which fell. A line chart of the values shows the overall trend. Many reports use both.
Write one sentence of summary. State the biggest change and the overall trend in plain words above the table.
A percentage change example
Here is six months of revenue for a small online shop. The data sits in columns A and B, starting in row 2.
| Month | Revenue | Change vs. prior month |
|---|---|---|
| January | 12,000 | — |
| February | 13,500 | 12.5% |
| March | 12,825 | -5.0% |
| April | 15,390 | 20.0% |
| May | 16,160 | 5.0% |
| June | 14,544 | -10.0% |
The formula in C3 is =(B3-B2)/B2, filled down to C7. February's change is (13,500 − 12,000) ÷ 12,000, which is 0.125, or 12.5%.
May shows 5.0% after rounding. The exact result is (16,160 − 15,390) ÷ 15,390, or about 5.003%.
The change from January to June uses a fixed base. The formula =(B7-$B$2)/$B$2 returns (14,544 − 12,000) ÷ 12,000, which is 21.2%. So revenue fell 10% in June, but it is still 21.2% above January.
That pair of numbers tells a fuller story than either alone. A report might say: "June revenue dropped 10% from May but remains 21.2% above January."
To chart it, select the Month and Change columns and insert a column chart. Positive and negative months then stand out at a glance.
Calculate percentage change in Excel with AI
When a file has thousands of rows and many columns, writing and checking formulas takes time. An AI tool can calculate the changes and summarize them for you.
Here is the method in three steps, using Powerdrill Bloom.
Step 1: Upload your Excel file
Upload the Excel or CSV file with your values. The Excel Calculations page says you can "Instantly calculate percentages or sum up entire columns of data in Excel."
Keep one row per period or item, with clear column headers. That helps the AI match the right old and new values.
Step 2: Ask for the calculation in natural language
Describe what you need. For example: "Calculate month-over-month percentage change in revenue, and the change since January, for each region."
The same page says you can input "your desired calculation request in text." Powerdrill Bloom "will recognize and apply the correct formula."
Step 3: Check the results and chart them
Spot-check two or three rows against your own formula. Then ask for a chart or a short summary of the biggest increases and decreases.
For a full analysis, the Excel AI Assistant "identifies trends, correlations, and key metrics in your Excel data automatically."
Common mistakes to avoid
These are the problems that come up most often with percentage change.
- Missing parentheses. =C2-B2/B2 divides first. Always write =(C2-B2)/B2.
- Dividing by the new value. The old value goes in the denominator, not the new one.
- Formatting twice. Multiplying by 100 and then applying Percent Style shows 1250% instead of 12.5%.
- Mixing up points and percent. A margin move from 10% to 12% is 2 points, or 20%.
- Relative reference for a fixed base. Use $B$2 so the base does not shift as you fill down.
- Hiding zeros. IFERROR blanks should be explained, not left silent.
- Averaging percentages. The average of monthly changes is not the total change. Compare the first and last values instead.
For growth over several years, use a compound annual growth rate instead. The Excel Calculations tool lists CAGR alongside percentages and growth rates.
When you are ready to turn a large sheet into a change report, try Powerdrill Bloom with last year's monthly sales.
Frequently asked questions
What is the formula for percentage change in Excel?
Use =(new-old)/old, such as =(C2-B2)/B2. Then select Percent Style on the Home tab, or press Ctrl+Shift+%, to show the result as a percentage.
How do I calculate percentage increase in Excel?
Use the same formula. If the new value is higher, the result is positive. Microsoft's example =(2500-2342)/2342 returns 6.75% after formatting.
How do I calculate percentage decrease in Excel?
Use the same formula. If the new value is lower, the result is negative. Microsoft's example =(2425-2500)/2500 returns -3.00%.
How do I calculate percentage change in a pivot table?
Right-click the value field, select Show Values As, and choose % Difference From. Pick the Base field, such as Month, and the Base item, such as (previous).
How do I avoid #DIV/0! in a percentage change formula?
Wrap the formula in IFERROR, such as =IFERROR((C2-B2)/B2, ""). Then explain in the report why those cells are blank.
Sources: Microsoft Support, Calculate percentages · Microsoft Support, Format numbers as percentages in Excel · Microsoft Support, Show different calculations in PivotTable value fields.