Learn How to Calculate Percentage Increase in Excel

Why You'd Want to Calculate Percentage Increase in Excel

Percentage increase shows up everywhere in real life, and knowing how to calculate it in Excel makes you faster and more accurate than punching numbers into a calculator. Whether you're tracking sales growth, monitoring budget changes, watching how your utility bills climb from season to season, or analyzing student test score improvements, percentage increase tells you the story of change in a way raw numbers sometimes hide.

America's Tire Credit Card Information Guide →

Here's a concrete example: Say your company's website had 15,000 visitors last month and 18,500 this month. You could say "we gained 3,500 visitors," but that doesn't tell you much about growth rate. When you calculate the percentage increase, you discover it's about 23.3% growth—and that number means something. It shows momentum. It reveals whether growth is accelerating or slowing. For comparing performance across different time periods or different departments (one starting from a smaller baseline than another), percentage increase is the real measuring stick.

Excel is the perfect tool for this task because it eliminates calculation mistakes and lets you apply the same formula to hundreds of rows of data instantly. Once you build the formula, you can reuse it, copy it down your spreadsheet, and let Excel handle the math while you focus on what the numbers actually mean for your work or studies.

Practical takeaway: Percentage increase transforms raw numbers into meaningful growth metrics that tell you whether changes matter and how much they matter.

Understanding the Percentage Increase Formula

The math behind percentage increase is straightforward, and understanding it matters before you build an Excel formula. The basic concept: you're comparing how much something changed (the difference) against where it started (the original value). Then you convert that ratio into a percentage.

Get Your Free Airbag Reset Modules Information Guide →

Here's the formula in plain terms:

• Take the new value
• Subtract the original value to find the change
• Divide the change by the original value
• Multiply by 100 to convert to a percentage

Written as an equation: ((New Value - Original Value) / Original Value) × 100

Let's walk through a real scenario. A coffee shop sold 200 cups on Monday and 240 cups on Tuesday. The change is 240 - 200 = 40 cups. The percentage increase is (40 ÷ 200) × 100 = 20%. So Tuesday's sales were 20% higher than Monday's.

Notice something important: the percentage increase is always calculated against the starting number, not the ending number. This matters because it affects your result. If you had mistakenly divided by 240, you'd get 16.67%, which tells a different story. Excel doesn't care which mistake you make—it just follows your formula—so building the formula correctly from the beginning saves you from spreading wrong numbers throughout your work.

Practical takeaway: Always divide the change by the original (starting) value, not the new value, or your percentages will be mathematically inaccurate.

Building Your First Percentage Increase Formula in Excel

Now let's move from the math into the actual spreadsheet. Open Excel and set up a simple structure to see how this works. In column A, list your original values. In column B, list your new values. In column C, you'll build the formula that calculates percentage increase.

Good Sam Credit Card Information Guide →

Click on the first cell in column C where you want your result to appear. Then type this formula exactly:

=((B2-A2)/A2)*100

What's happening in this formula: B2 is your new value. A2 is your original value. The parentheses force Excel to do the subtraction first (B2-A2), then divide that result by A2, then multiply by 100. Press Enter, and Excel shows you the percentage increase as a number.

Let's use a practical example you can type right now. Put 50 in cell A2. Put 65 in cell B2. When you enter the formula =((B2-A2)/A2)*100 in C2, Excel displays 30, meaning a 30% increase from 50 to 65. That's correct: the change is 15, and 15 divided by 50 equals 0.3, which is 30%.

If you're working with dozens or hundreds of rows, you don't need to retype the formula each time. Click on the cell with your formula, then grab the small square handle at the bottom-right corner of the cell (called the fill handle) and drag it down as many rows as you need. Excel automatically adjusts the cell references (A2, B2 become A3, B3, then A4, B4, and so on), applying the same calculation to each row.

Practical takeaway: A single formula in Excel can handle percentage calculations for unlimited rows of data through the fill-down feature, saving enormous amounts of time.

Formatting Your Results So They Actually Look Like Percentages

There's a small but important detail many people overlook: the way you format the number in Excel. When you use the formula =((B2-A2)/A2)*100, Excel gives you a plain number like 30. That works fine if you remember that 30 means 30%, but it's easy to misread when you're scanning a spreadsheet quickly.

Learn Which States Allow Anonymous Lottery Claims →

Excel has a built-in percentage format that handles the multiplication by 100 automatically. This means you can actually write your formula without the *100 at the end, like this:

=((B2-A2)/A2)

Then format those cells as percentages, and Excel displays the result as 30% automatically. This approach prevents a common mistake: forgetting whether you already multiplied by 100, then applying percentage formatting anyway, which would show your result as 3000%.

To format cells as percentages in Excel, select the cells containing your results. Right-click and choose "Format Cells." Click the "Number" tab. Select "Percentage" from the Category list on the left. You'll see options to choose how many decimal places to display. For most situations, one or two decimal places work well (showing 30.2% instead of just 30% gives more precision without becoming cluttered).

Alternatively, after selecting your cells, look at the toolbar. You'll often see a percentage symbol (%) button. Clicking it applies percentage formatting instantly. Either way, your numbers now read as percentages, which makes your spreadsheet clearer and less prone to misinterpretation.

Practical takeaway: Formatting numbers as percentages prevents confusion and makes spreadsheets easier to read at a glance.

Calculating Percentage Increase When Your Data Includes Negative Numbers

The formula works differently when your original value is negative or when the new value is negative, and these scenarios pop up more often than you'd think. Understanding what's happening mathematically helps you interpret results correctly.

Get Your Free Valvoline Hours and Location Guide →

Imagine a company that lost $10,000 in January (shown as -10,000 in your spreadsheet) and lost $5,000 in February (shown as -5,000). Using the standard formula: ((-5,000 - (-10,000)) / (-10,000)) × 100 = ((5,000) / (-10,000)) × 100 = -50%. The negative sign tells you the value increased (losses decreased), but the calculation can feel counterintuitive.

Here's another scenario: a company gained $10,000 in January and lost $5,000 in February. The calculation becomes: ((-5,000 - 10,000) / 10,000) × 100 = ((-15,000) / 10,000) × 100 = -150%. This shows a 150% decrease from positive to negative, which is mathematically correct but can be hard to interpret.

The formula itself works fine in these situations—Excel doesn't care about signs—but you should be cautious about drawing conclusions. A -150% change isn't really "more of a decrease" than a -50% change; the formula is doing what it's supposed to do mathematically, but the context matters. Sometimes when you