To calculate a percentage increase in Excel, subtract the old value from the new value, divide by the old value and format the result as a percentage. The formula is short, but the details cause most of the trouble: the order of the cells, zero values, negative numbers, the percentage format and how to increase a number by a percentage. This guide shows the exact formulas with worked examples, how to fill them down a column, how to add or subtract a percentage from a price, how to handle errors and how to build a clean report.
Updated November 2026
In this guide
- The percentage increase formula
- Step-by-step example
- Examples table
- Increase a number by a percentage
- Handling zero and error values
- Percentage increase over several periods
- Percentage of total and percentage difference
- Formatting tips
- Worked example: a price list update
- Percentage increase with a helper table
- Percentage increase with PivotTables and charts
- Quick recap
- Common mistakes
The percentage increase formula
With the old value in A2 and the new value in B2, the formula is =(B2-A2)/A2. Press Enter, then select the cell and choose Percentage from the Home tab. The result is positive for an increase and negative for a decrease. For example, if A2 is 80 and B2 is 100, the formula returns 0.25, which Excel shows as 25 percent. The same formula covers both increase and decrease, and you can label the column “Change”. For the theory and more examples, read our guide to calculating percent change.
Step-by-step example
- Enter the old values in column A and the new values in column B, with headings in row 1.
- In C2 type
=(B2-A2)/A2and press Enter. - Click C2, then on the Home tab click the Percent Style button (the % icon).
- Use the Increase Decimal button to show one or two decimals.
- Double-click the fill handle at the bottom right of C2 to copy the formula down.
If you format first and type the number afterward, Excel may treat 25 as 25 percent, so enter formulas rather than typed percentages whenever you can.
Examples table
These sample rows show the result of the formula.
| Old (A) | New (B) | Formula | Result |
|---|---|---|---|
| 80 | 100 | =(B2-A2)/A2 | 25.0% |
| 200 | 170 | =(B3-A3)/A3 | -15.0% |
| 50 | 65 | =(B4-A4)/A4 | 30.0% |
| 1,200 | 1,500 | =(B5-A5)/A5 | 25.0% |
| 45 | 36 | =(B6-A6)/A6 | -20.0% |
Increase a number by a percentage
To increase a price by a given percent, multiply by 1 plus the percent. If the price is in A2 and the increase is in B2 as 15 percent, use =A2*(1+B2). A price of 200 becomes 200 times 1.15, which is 230. For a decrease, use =A2*(1-B2), so a 20 percent discount on 250 gives 200. If you only want the amount of the increase, use =A2*B2. Store the percent in its own cell, such as B1, and refer to it with an absolute reference like =A2*(1+$B$1). When the rate changes, you update one cell and the whole sheet recalculates.
Handling zero and error values
If the old value is zero, the formula returns a #DIV/0! error, since you cannot divide by zero. Guard it with =IF(A2=0,"n/a",(B2-A2)/A2), or use IFERROR: =IFERROR((B2-A2)/A2,""), which returns a blank cell on any error. See Microsoft’s page on the IF function and our guide to IF statements in Excel. Text values such as “N/A” in your data will cause a #VALUE! error, so clean the data or wrap the formula. If the old value is negative, the result can be misleading: from minus 50 to minus 25 the formula gives minus 50 percent even though the number improved. Use =(B2-A2)/ABS(A2) to get a result with the intuitive sign.
Percentage increase over several periods
For a series of values, such as monthly sales in B2 to B13, compare each month with the previous one using =(B3-B2)/B2 in C3 and fill down. To find the growth from the first to the last month, use =(B13-B2)/B2. For a compound growth rate, such as the average monthly growth, use =(B13/B2)^(1/11)-1, where 11 is the number of intervals. Do not average the monthly percentages, because that ignores compounding. If you want to see the growth on a chart, create a line chart of the values and a column chart of the percentage change.
Percentage of total and percentage difference
A related task is to find what percent one value is of another. The formula is =part/total, for example =B2/B$10 to find each item as a share of the total in B10. Percentage difference between two values, with no direction, uses =ABS(A2-B2)/AVERAGE(A2,B2). For the function reference, see Microsoft’s page on the AVERAGE function. Choose the formula that matches your question, because the percent increase and percent difference give different numbers for the same data.
Formatting tips
Use the Percent Style for the cell, rather than multiplying by 100 in the formula. If you multiply by 100 and also format as a percent, the result will show as 2,500 percent. Set the number of decimals consistently, and use conditional formatting to color increases green and decreases red: select the column, choose Conditional Formatting, then Highlight Cells Rules, and set a rule for values greater than zero and less than zero. Add custom formats such as +0.0%;-0.0%;0.0% to show a plus sign in front of positive changes, which makes reports easier to scan.
Worked example: a price list update
Suppose you sell 5 products and plan a price rise. Put current prices in A2:A6 (40, 55, 72, 90, 120) and the planned rate in E1 as 8 percent. In B2 type =A2*(1+$E$1) and fill down. The new prices are 43.20, 59.40, 77.76, 97.20 and 129.60. To show the dollar increase use =B2-A2, which gives 3.20, 4.40, 5.76, 7.20 and 9.60. To confirm that each row rose 8 percent, use =(B2-A2)/A2 in column D, and every row returns 8.0 percent. Total revenue changes the same way: if you sell 100 of each product, old revenue is (40+55+72+90+120) times 100, which is 37,700, and new revenue is 40,716. The check is 37,700 times 1.08, which equals 40,716. Reconciling like this catches formula mistakes before you send a quote to a client.
Percentage increase with a helper table
For reports, build a small table with the columns Item, Last year, This year, Change and Percent. The change column uses =C2-B2 and the percent column uses =D2/B2. At the bottom, add a total row with =SUM(B2:B10) and =SUM(C2:C10), and calculate the total percent from those totals, not by averaging the row percents. If one product has a very small base, its percent may look huge, so add a column for the absolute change so readers can judge the impact. Sort the table by the Change column to see the biggest movers first.
Percentage increase with PivotTables and charts
PivotTables can also show percent change. Add your date field to Rows and your sales to Values twice. For the second sales field, click Value Field Settings, choose Show Values As, then choose “% Difference From” and set the base field to the previous item. Excel then shows month-over-month change without any formulas. For a chart, select the percent column and insert a column chart. Format negative values in a different color so that decreases stand out. Keep titles clear, for example “Monthly sales growth, percent”, and show the base period in the subtitle.
Quick recap
Use =(new-old)/old for percentage change and =old*(1+rate) to add a percentage. Format results with Percent Style, protect against zero with IF or IFERROR, and keep the rates in their own cells. Check a few rows by hand, such as 80 to 100 being 25 percent, to confirm that your sheet is correct before you share it with a client or a manager.
Common mistakes
The most common mistake is dividing by the new value, which gives the wrong result. Another is forgetting the parentheses, which makes Excel divide first: =B2-A2/A2 returns B2 minus 1. A third is typing the percent as a whole number, so 15 is treated as 1500 percent. A fourth is to leave cells formatted as text, which makes formulas appear as text instead of results. If a formula shows as plain text, change the cell format to General and press F2 then Enter. Finally, double-check that the old and new columns are in the right order, because swapping them reverses the sign.
Frequently asked questions
What is the formula for percentage increase in Excel?
Use =(new-old)/old and format the result as a percentage.
How do I add a percentage to a number in Excel?
Multiply the number by 1 plus the percentage, for example =A2*(1+15%).
Why does my percent change show #DIV/0!?
The old value is zero. Use IF or IFERROR to handle it.
How do I calculate percentage decrease in Excel?
Use the same formula. A negative result is a decrease.
How do I show the percent sign?
Select the cell and click Percent Style on the Home tab.


