Percentage increase in Excel is one of those calculations that looks simple until you need to apply it across a real spreadsheet with dozens of rows, mixed formats, and values that sometimes go down instead of up. Think about it: the good news is that Excel does not require a special function for this. But once you understand the underlying formula and how Excel stores percentages, you can calculate percentage increase accurately, format it cleanly, and avoid the common errors that make results look wrong. This guide walks through the exact formula, a step-by-step example, formatting tips, troubleshooting advice, and answers to frequently asked questions so you can use percentage increase in Excel with confidence Turns out it matters..
What Percentage Increase Actually Means
A percentage increase measures how much a value has grown relative to its original value. If a product’s price rises from $50 to $60, the increase is $10. To express that increase as a percentage of the original price, divide the increase by the original value:
($60 − $50) ÷ $50 = 0.20 = 20%
That 20% means the new value is 20% larger than the old value. The same logic applies in Excel. The only difference is that Excel stores the result as a decimal by default, and you choose whether to display it as a percentage.
The general formula is:
Percentage Increase = (New Value − Old Value) ÷ Old Value
In Excel cell terms, if the old value is in A2 and the new value is in B2, the formula is:
=(B2-A2)/A2
This returns a decimal such as 0.Worth adding: 2. Format that cell as a percentage, and Excel displays 20%.
Step-by-Step: Calculate Percentage Increase in Excel
Step 1: Set Up Your Data Clearly
Create two columns with clear labels. For example:
| A | B |
|---|---|
| Old Value | New Value |
| 50 | 60 |
| 120 | 150 |
| 200 | 180 |
Put the old value in column A and the new value in column B. That's why starting in row 2 keeps row 1 available for headers. Clear labels matter because the most common Excel mistake is reversing the old and new values That alone is useful..
Step 2: Enter the Formula
Click the cell where you want the result, such as C2, and type:
=(B2-A2)/A2
Press Enter. For the first row, 60 − 50 = 10, and 10 ÷ 50 = 0.Excel subtracts the old value from the new value, then divides by the old value. 2 Easy to understand, harder to ignore..
Step 3: Format the Result as a Percentage
Select the result cell, go to the Home tab, and click the % button in the Number group. You can also press Ctrl + Shift + % on Windows or Command + Shift + % on Mac. That's why the cell now shows 20% instead of 0. 2 The details matter here. No workaround needed..
If you want one decimal place, use the Increase Decimal button. For whole-number percentages, use Decrease Decimal Not complicated — just consistent..
Step 4: Copy the Formula Down
Drag the fill handle from C2 down through the rest of your rows. On top of that, excel adjusts the relative references automatically, so row 3 uses =(B3-A3)/A3, row 4 uses =(B4-A4)/A4, and so on. This is why you should avoid typing the formula separately for every row.
Step 5: Interpret Positive and Negative Results
A positive result means an increase. A negative result means a decrease. On top of that, for example, if the old value is 200 and the new value is 180, the formula returns −0. 10, which displays as −10%. Here's the thing — that is a 10% decrease, not a 10% increase. If you want to label decreases clearly, you can use a custom number format or a helper column with an IF formula, but the underlying calculation is still correct It's one of those things that adds up..
A Complete Example With Real Numbers
Suppose you track monthly sales:
| Month | Old Sales | New Sales | Percentage Change |
|---|---|---|---|
| January to February | 1,000 | 1,200 | =(B2-A2)/A2 → 20% |
| February to March | 1,200 | 1,500 | =(B3-A3)/A3 → 25% |
| March to April | 1,500 | 1,350 | =(B4-A4)/A4 → −10% |
The first two rows show growth. If someone asks for the “percentage increase” from March to April, the mathematically honest answer is −10%, or a 10% decrease. The third row shows a decline. Excel does not hide that; it simply reports the signed change It's one of those things that adds up. But it adds up..
Formatting Tips That Prevent Confusion
Use Percentage Format, Not Manual Multiplication
You can write =(B2-A2)/A2*100 and get 20 instead of 0.Day to day, 2. That works, but it is usually a bad habit. Multiplying by 100 turns the result into a plain number, so Excel no longer treats it as a percentage. In real terms, if you later use that cell in another formula, you may introduce errors. The cleaner approach is to keep the decimal result and apply percentage formatting And it works..
Add Conditional Formatting for Increases and Decreases
To make changes visually obvious, select your percentage column and use Conditional Formatting → Highlight Cells Rules → Greater Than for positive values and Less Than for negative values. You can color increases green and decreases red. This is especially useful in dashboards and reports.
Use a Custom Format for Signed Percentages
A custom number format such as +0.So 0%;-0. 0% displays positive results with a plus sign and negative results with a minus sign. That makes the direction of change immediately clear without adding extra text.
Common Mistakes and How to Fix Them
Reversing Old and New Values
If you use =(A2-B2)/B2 instead of =(B2-A2)/A2, you calculate the change in the wrong direction. Always subtract the old value from the new value, then divide by the old value.
Forgetting Parentheses
Excel follows the order of operations. If you type =B2-A2/A2, Excel divides A2 by A2 first, then subtracts. But that is not the percentage increase formula. Always wrap the subtraction in parentheses: =(B2-A2)/A2.
Dividing by the New Value
Dividing by the new value answers a different question: “What percentage of the new value is the change?And ” That is not percentage increase. The denominator must be the old value.
Dividing by Zero
If the old value is 0, the formula returns **#D
IV/0!** error, because division by zero is undefined. Wrap the formula in an error handler such as =IFERROR((B2-A2)/A2,"n/a") or test the old value first with =IF(A2=0,"n/a",(B2-A2)/A2). Decide what the message should mean in your context: a move from zero to any positive number is technically an infinite increase, so most reports label it "new" or "no baseline" rather than showing a percentage Worth keeping that in mind. That alone is useful..
Negative Starting Values
When the old value is negative, the standard formula produces a result that is mathematically valid but often misleading. A change from −100 to −50 is an improvement, yet =(B2-A2)/A2 returns −50%. In such cases, either use the absolute value of the baseline, =(B2-A2)/ABS(A2), or report the raw difference instead of a percentage and add a footnote explaining the choice And that's really what it comes down to..
This changes depending on context. Keep that in mind.
Blank Cells and Text
Excel treats an empty cell as zero, so a blank old value can silently produce a division error or a misleading result. If your data may contain blanks, test for them explicitly: =IF(OR(A2="",B2=""),"",(B2-A2)/A2). Similarly, numbers stored as text will not behave as expected, so use VALUE() or paste-special conversion before calculating.
Rounding Too Early
Displaying a cell as 0.On top of that, what you should avoid is rounding inside the formula itself, for example with =ROUND((B2-A2)/A2,2), unless you have a specific reason. That is usually what you want. 0% only changes how the value looks; the underlying number keeps its full precision. Rounded intermediate values compound when you build further calculations on top of them Worth keeping that in mind..
Counterintuitive, but true.
Confusing Percentage Points With Percent
If a rate moves from 10% to 12%, the increase is 2 percentage points, but the percentage increase is 20%. Mixing these two ideas is one of the most frequent sources of error in reported figures, so state clearly which one you are quoting.
Choosing the Right Tool for the Job
For a single comparison, the basic formula is all you need. For large datasets, SUM the old and new columns first and compute one overall change, which is often more meaningful than averaging individual percentages. For a long series of periods, consider a line chart with a secondary axis or a column chart of the percentage column so trends and reversals stand out. An average of ratios can be distorted by small baselines, whereas a total-to-total comparison reflects the actual movement in your data Most people skip this — try not to..
Conclusion
Percentage increase in Excel comes down to one idea: measure the difference, then express that difference relative to the starting point. Keep the result as a true decimal and apply percentage formatting, add signs and colors so the direction is obvious, and guard against the cases that break the arithmetic, namely zero baselines, negative baselines, blanks, and text stored as numbers. Plus, handle those edge cases deliberately, and your figures will survive scrutiny. Practically speaking, the remaining work is presentational and defensive. The formula =(New−Old)/Old handles growth, decline, and reversal alike, returning a signed result that tells you both size and direction. Get them right, and a simple spreadsheet becomes a reliable record of change over time.