ΣBasics & math12 min read ·

How to Calculate Percentage Change in Excel

Calculate percentage change in Excel with =(new-old)/old. Percent increase and decrease, month-over-month change, a fixed baseline and zero values.

Quick answer

Percentage change is the new value minus the old value, divided by the old value, like =(B3-B2)/B2. Format the cell as a percentage with Ctrl+Shift+%. A positive result is an increase and a negative one is a decrease.

On this page ⌄
  1. The percentage change formula
  2. Format the result as a percentage
  3. Percent increase and percent decrease
  4. Month-over-month change: copy the formula down
  5. Percentage change from a fixed starting point ($B$2)
  6. When the old value is zero or blank
  7. Percentage change vs percentage of total
  8. Increase or decrease a number by a percentage
  9. Round a percentage change
  10. Common percentage change mistakes
  11. Frequently asked questions about percentage change
  12. Does the formula work in every version of Excel?
  13. Key takeaways

Percentage change tells you how much a number went up or down compared with where it started. If coffee sales go from 1,180 to 1,395, saying they're "up 215" doesn't tell you much. Saying they're up 18.2% does, and you can compare it with any other month or product. Excel has no percentage change function, so you write the formula yourself:

=(new_value - old_value) / old_value

Subtract the old value from the new one, divide by the old value, and format the result as a percentage. A positive result is an increase, and a negative result is a decrease.

The examples use a coffee shop's monthly sales in A1:C7:

A: MonthB: CoffeeC: Pastries
2Jan1,240610
3Feb1,180540
4Mar1,395720
5Apr1,310655
6May1,460780
7Jun1,525805

The percentage change formula

The formula compares two numbers:

PartWhat it meansExample
old_valueThe starting point: last month, last year or a budgetB2
new_valueThe number you're comparing with itB4

How much did coffee sales grow from January to March?

=(B4-B2)/B2→ 0.125

Excel does the part in brackets first: 1,395 minus 1,240 is 155. Then it divides by 1,240. The answer, 0.125, is a decimal, because 155 is 0.125 of 1,240. As a percentage, that's 12.5%.

The brackets matter. Excel divides before it subtracts, so without them it works out B2/B2 first and gives a very different answer. The mistakes section shows what you'd get.

You'll also see this shorter version:

=B4/B2-1→ 0.125

B4/B2 gives 1.125, which means March sold 112.5% of January's amount. Take away 1, which is 100%, and you're left with the change. Both formulas give the same answer, so use whichever you find easier to read. The first one follows the way people explain it: the change, divided by where you started.

Format the result as a percentage

Excel shows 0.125 because a percentage is just a decimal. 12.5% and 0.125 are the same number, written two ways. To show it as a percentage, select the cell and either:

  • click Percent Style, the % button in the Number group on the Home tab, or
  • press Ctrl+Shift+%.

Both apply the Percentage format with no decimal places, so 0.125 shows as 13%. Excel rounds what you see to the nearest whole percent, and halves round away from zero. The cell still holds 0.125, and any formula that uses it gets 0.125.

To see the decimals, click Increase Decimal in the same group. One click shows 12.5%. To pick the number of places directly, press Ctrl+1 to open Format Cells, choose Percentage and set Decimal places.

From here on, results are shown as percentages with one decimal place:

=(B4-B2)/B2→ 12.5%

You can also type a percentage straight into a cell. Type 12.5% and Excel stores 0.125 and applies a percentage format for you.

Percent increase and percent decrease

You don't need a separate formula for a decrease. When the new value is smaller, the same formula gives a negative result. Coffee sales fell from January to February:

=(B3-B2)/B2→ -4.8%

1,180 minus 1,240 is -60, and -60 divided by 1,240 is about -0.048, a 4.8% decrease. Pastries fell further in the same month:

=(C3-C2)/C2→ -11.5%

To label the direction in words, compare the two months with IF:

=IF(B3<B2, "Down", "Up")→ Down

Or let the number format show it. Press Ctrl+1, choose Custom, and type one of these in the Type box:

Custom format12.5% shows as-4.8% shows as
0.0%;[Red]-0.0%12.5%-4.8%, in red
+0.0%;-0.0%;0.0%+12.5%-4.8%

The parts are separated by semicolons: the first is for positive numbers, the second for negative numbers and the third for zero.

Two things are worth knowing about the size of a change. When the values can't go below zero, a decrease can never be more than 100%, because falling all the way to zero is -100%. An increase has no limit: doubling is a 100% increase, and tripling is 200%.

Month-over-month change: copy the formula down

Usually you want the change for every row, each compared with the row above. Leave D2 empty, because January has no month before it, and type this in D3:

=(B3-B2)/B2→ -4.8%

Then copy it down to D7. Drag the fill handle, the small square at the bottom-right corner of the cell, or double-click it. Each copy compares a month with the one before:

A: MonthB: CoffeeFormula in DD shows
3Feb1,180=(B3-B2)/B2-4.8%
4Mar1,395=(B4-B3)/B318.2%
5Apr1,310=(B5-B4)/B4-6.1%
6May1,460=(B6-B5)/B511.5%
7Jun1,525=(B7-B6)/B64.5%

This works because the references are relative. Copied one row down, B3 becomes B4 and B2 becomes B3. March was the best month for growth, and April gave some of it back.

Don't fill D2 as well. =(B2-B1)/B1 would try to subtract the header "Coffee", and return #VALUE!.

Percentage change from a fixed starting point ($B$2)

Sometimes every month should be compared with the same one, such as January, the start of the year. Every copy of the formula has to use B2, so lock it with dollar signs. In E3:

=(B3-$B$2)/$B$2→ -4.8%

Copy it down. B3 moves to B4, B5 and B6, while $B$2 stays on January:

=(B4-$B$2)/$B$2→ 12.5%
=(B5-$B$2)/$B$2→ 5.6%
=(B6-$B$2)/$B$2→ 17.7%

Row 7 compares June with January, the growth over the half year. That's the question in the Premium percentage change exercise, so we'll leave that one for you.

Without the dollar signs, the formula in E3 is the same as the one in D3, and copying it gives month-over-month changes instead. There's no error to warn you. The first row is right, and the rest answer a different question. Here's what E4 shows instead of 12.5%:

=(B4-B3)/B3→ 18.2%

To add the dollar signs, click on B2 in the formula bar and press F4. The absolute vs relative references guide explains how F4 works and when to lock only the row or the column.

When the old value is zero or blank

Percentage change divides by the old value, so a zero or an empty old value gives #DIV/0!. Say the shop starts selling smoothies in February and logs them in column F, with January left empty:

A: MonthF: Smoothies
2Jan
3Feb90
4Mar135
=(F3-F2)/F2→ #DIV/0!
=(F4-F3)/F3→ 50.0%

The error is fair. Growth from nothing can't be measured as a percentage: going from 0 to 90 isn't a 90% or a 100% increase. So the fix is to decide what to show instead.

With IFERROR, you give a fallback for when the division fails:

=IFERROR((F3-F2)/F2, "New")→ New
=IFERROR((F4-F3)/F3, "New")→ 50.0%

Or test the old value with IF first. An empty cell counts as 0 in a comparison, so F2=0 catches both a zero and a blank:

=IF(F2=0, "New", (F3-F2)/F2)→ New

The IF version is the more careful one. It only steps in when the old value is zero or blank, so if a cell holds text by mistake, you still see #VALUE! instead of a misleading "New". To make the cell look empty, use "" instead of "New", but bear in mind that other formulas can't do math with it. The IFERROR guide explains why.

A blank new value causes a quieter problem. Copy the month-over-month formula one row past the data, and July's empty cell counts as 0:

=(B8-B7)/B7→ -100.0%

There's no error, just a fake 100% drop. Check for a blank new value too, and the cell stays empty until July's number is typed in:

=IF(B8="", "", (B8-B7)/B7)

Percentage change vs percentage of total

These two get mixed up because both end in a percent sign, but they answer different questions:

Percentage changePercentage of total
QuestionHow much did it grow or shrink?What share of the whole is it?
Formula(new - old) / oldpart / total
Coffee exampleMarch compared with February: 18.2%March's share of six months: 17.2%

Here's March's share of all the coffee sold from January to June:

=B4/SUM($B$2:$B$7)→ 17.2%

March sold 1,395 of the 8,110 coffees. The total is locked, so you can copy the formula down to get every month's share, and the shares add up to 100%. In Excel for Microsoft 365, =PERCENTOF(B4, B2:B7) gives the same answer.

A percentage change compares the same thing at two different times. A percentage of total compares a part with the whole. If you see more than 100%, it can't be a share of a total, because a part can't be bigger than the whole.

Your turn. Every percentage of total starts with a total. This exercise uses the site's sales log, with each order's revenue in F2:F11. Find the total revenue with one formula.

Try it yourself

A live spreadsheet. Type a formula and press Enter to check it.

Exercise 1 of 11SUM

What was the total revenue for all orders?

Write your formula in the green cell, I2.

q1-orders.xlsx
fx
1DateRegionRepProductUnitsRevenue
2Jan 4, 2026NorthAvaLaptop3$3,600.00Total revenue
3Jan 9, 2026SouthLeoMonitor5$1,250.00
4Jan 15, 2026NorthMayaLaptop2$2,400.00
5Jan 22, 2026EastSamKeyboard12$720.00
6Feb 3, 2026WestZoeMonitor4$1,000.00
7Feb 11, 2026NorthAvaKeyboard8$480.00
8Feb 19, 2026SouthIvyLaptop4$4,800.00
9Feb 27, 2026EastSamMonitor6$1,500.00
10Mar 6, 2026WestNoahLaptop1$1,200.00
11Mar 14, 2026NorthMayaMonitor7$1,750.00
12
13

Click a cell to add it to your formula, drag to select a range, or click a column letter for the whole column.

With the total in I2, =F2/$I$2 copied down would give each order's share of revenue.

Increase or decrease a number by a percentage

Going the other way, you have a number and a percentage, and you want the new number. Multiply by 1 plus the percentage. With the number in A2 and the percentage in B2:

=A2*(1+B2)

Say the shop is aiming for 10% more coffee sales in July than in June. Type 10% in H1, and in H2:

=B7*(1+$H$1)→ 1677.5

1 plus 10% is 110%, so this returns 110% of June's 1,525. For a decrease, type a negative percentage in H1. With -10%:

=B7*(1+$H$1)→ 1372.5

The same formula handles both, so you can try different targets by changing H1. If you'd rather type the decrease into the formula, =B7*(1-10%) also returns 1372.5.

The 1 is what keeps the original amount. =B7*$H$1 with 10% in H1 returns only the increase, 152.5. And =B7+10% adds 0.1, so it returns 1525.1.

To find the number before a change, divide instead. March's 1,395 was 12.5% more than January's:

=B4/(1+12.5%)→ 1240

Taking 12.5% off 1,395 doesn't work: =B4*(1-12.5%) gives 1220.625, because 12.5% of 1,395 is more than 12.5% of 1,240.

Round a percentage change

The number format only rounds what you see. To round the value itself, use ROUND. A percentage is stored as a decimal, so the digits argument counts decimal places in the decimal, not in the percentage:

=ROUND((B4-B3)/B3, 2)→ 18.0%
=ROUND((B4-B3)/B3, 3)→ 18.2%

2 digits keeps 0.18, a whole percentage. 3 digits keeps 0.182, a percentage with one decimal place. If you want 18.2% and use 1, you get 0.2, which shows as 20.0%.

Round the value when the rounded number is the one you want to keep, for example when another formula compares it with a target, or a report has to add up to exactly what's shown. For display, the format is enough.

To put a percentage into a sentence, use TEXT, which rounds and formats in one go:

="Coffee grew "&TEXT((B4-B3)/B3, "0.0%")&" in March"→ Coffee grew 18.2% in March

Common percentage change mistakes

ProblemWhat's going onFix
A huge result, like 139400.0%The brackets are missing. =B4-B3/B3 divides first and returns 1394=(B4-B3)/B3
15.4% instead of 18.2%The formula divides by the new value: =(B4-B3)/B4Divide by the old value
1822.0% instead of 18.2%The formula multiplies by 100, and the Percentage format multiplies by 100 againRemove the *100, or don't format the cell as a percentage
An increase shows as negativeThe subtraction is the wrong way round: =(B3-B4)/B3New minus old: =(B4-B3)/B3
Every month is compared with the month before, not JanuaryThe starting cell moved when the formula was copiedLock it: $B$2
#DIV/0!The old value is 0 or blankTest it with IF, or wrap the formula in IFERROR
-100.0% in rows past the dataThe new value is blank, which counts as 0=IF(B8="", "", (B8-B7)/B7)
1525.1 instead of 1677.5=B7+10% adds 0.1 to the number=B7*(1+10%)
12.5% shows as 13%Percent Style shows no decimal placesClick Increase Decimal

Frequently asked questions about percentage change

Is there a percentage change function in Excel?

No. Excel has no built-in function for percentage change, so you write =(B3-B2)/B2 yourself, with the new value first and the old value twice. Excel for Microsoft 365 has PERCENTOF, but that's for a percentage of total, not a change.

What's the difference between percent and percentage points?

Percentage points are the plain difference between two percentages. Percent change is that difference compared with where you started. If a share grows from 20% to 25%, it's up 5 percentage points, but it grew by 25%:

=(25%-20%)/20%→ 25.0%

Why don't a 50% drop and a 50% rise cancel out?

Because each percentage uses a different starting point. Cut 1,000 by 50% and you have 500. A 50% rise from 500 is only 250, which takes you to 750. To get back to 1,000, you'd need a 100% increase.

It's the same in the coffee data. February's -4.8% and March's 18.2% add up to 13.4%, but January to March was a 12.5% increase.

How do I calculate percentage change with negative numbers?

Say profit goes from -200 to 100. The usual formula divides by -200 and returns -150%, a decrease, even though profit went up. A common fix is to divide by the absolute value of the old number:

=(100-(-200))/ABS(-200)→ 150.0%

Now the sign shows the direction. Use results like this with care, though. When the old value is negative or close to zero, a percentage change can be misleading, and the change in dollars is often clearer.

How do I find the average monthly growth rate?

Don't average the monthly percentages. Pastries' five monthly changes average 7.0%, but growing 610 by that much every month for five months gives about 857, not 805. Use the compound growth rate instead:

=(C7/C2)^(1/5)-1→ 5.7%
=RRI(5, C2, C7)→ 5.7%

There are five steps from January to June, so it's 1/5, not 1/6. Grow 610 by this rate five times and you get 805. RRI does the same calculation: its arguments are the number of periods, the starting value and the ending value.

Does the formula work in every version of Excel?

Yes. Percentage change only uses subtraction and division, so it works the same way in every version of Excel, on Windows and Mac, and in Excel for the web. IFERROR needs Excel 2007 or later, and PERCENTOF needs Excel for Microsoft 365. Google Sheets uses the same formula. Format the result with Format > Number > Percent. For Microsoft's own examples, see Calculate percentages.

For more practice, the basics topic has Premium exercises on percentage change, share of the total and rounding to the nearest 10, all on the same coffee shop data. The free IFERROR exercise practices the #DIV/0! fix.

Key takeaways

  • Percentage change is new minus old, divided by old: =(B3-B2)/B2. Put brackets around the subtraction. =B3/B2-1 gives the same answer.
  • Format the result with Ctrl+Shift+% or the % button. It shows whole percentages, so click Increase Decimal for more detail.
  • A negative result is a decrease. To compare every row with one starting point, lock it with $B$2.
  • Handle zero or blank old values with IF or IFERROR, and use =A2*(1+B2) to apply a percentage change to a number.

Practice

Keep going with ROUND exercises

Reading gets you started. Solving a few of these is what makes it stick.

  1. 1Total revenueFreeWhat was the total revenue for all orders?→
  2. 2Percentage change PremiumBy what percentage did coffee sales grow from January to June?→
  3. 3Share of the total PremiumWhat share of all the items sold over the six months were pastries?→
  4. 4Round to the nearest 10 PremiumWhat were average monthly coffee sales, rounded to the nearest 10?→
  5. 5Avoid #DIV/0!FreeWork out the cost per unit for Travel (Actual ÷ Units). Units is 0, so show 0 instead of an error.→
All basics & math exercises →
Brian Millot

About the author

Brian Millot

Brian Millot is an indie hacker based in France who builds small, focused web products. He built and runs Excel Formula Practice, from the in-browser spreadsheet that checks your formulas to the exercise library, and he writes the formula guides.

Related guides

Practice makes formulas

Stop reading. Start typing formulas.

Every exercise is a real spreadsheet with instant feedback. The first two in every topic are free, no sign-up needed.