The basic formula for percent increase

To calculate percent increase in Excel, subtract the original value from the new value, divide by the original value, then multiply by 100. The formula is: =((New Value - Original Value) / Original Value) * 100

If your original value is in cell A1 and your new value is in cell B1, you would type =((B1-A1)/A1)*100 into any empty cell. Excel will return the percent increase as a number — for example, 25 for a 25% increase.

The order matters. If you subtract new from original instead, you'll get a negative number, which represents a percent decrease rather than increase. Excel doesn't care which direction you're measuring; the formula itself tells you whether the change went up or down.

Key Takeaways

  • The percent increase formula in Excel is =((New Value - Original Value) / Original Value) * 100, where you replace each term with a cell reference or number.
  • You can remove the * 100 and format the cell as a percentage instead, which gives the same result but displays as 25% rather than 25.
  • To calculate percent increase for multiple rows at once, enter the formula in one cell, then copy it down — Excel automatically adjusts the cell references for each row.
  • If your original value is zero, Excel will show a #DIV/0! error because you cannot divide by zero; this is a real mathematical problem, not a mistake in your formula.

Setting up your data in columns

Organize your data so the original values are in one column and the new values are in another. For example, put all original values in column A and all new values in column B. This makes it easier to write one formula and copy it down for all your rows.

Label your columns clearly — "Original Value" in A1, "New Value" in B1, and "Percent Increase" in C1. This helps you remember what each column contains when you come back to the spreadsheet later. Start your actual data in row 2, leaving row 1 for headers.

Writing and copying the formula down

Click on cell C2 (or whichever cell is in your percent increase column, first data row). Type the formula =((B2-A2)/A2)*100 and press Enter. Excel calculates the result for that row.

To apply the same formula to all your other rows, click back on C2, then grab the small square at the bottom-right corner of the cell (called the fill handle) and drag it down to the last row of your data. Excel copies the formula and automatically changes the row numbers — C3 will contain =((B3-A3)/A3)*100, C4 will contain =((B4-A4)/A4)*100, and so on.

If dragging feels awkward, you can also click C2, copy it (Ctrl+C or Cmd+C), select the range C3 to your last row, and paste (Ctrl+V or Cmd+V). Both methods produce the same result.

Using percentage formatting instead of multiplying by 100

Some people prefer to write the formula as =((B2-A2)/A2) without the * 100 at the end. This gives you a decimal — 0.25 instead of 25. You can then format that cell as a percentage, and Excel will display it as 25%.

To format as a percentage, select your cells with the decimal results, then right-click and choose "Format Cells." Click the "Number" tab, select "Percentage" from the category list, and click OK. Excel multiplies the decimal by 100 and adds the % symbol automatically.

Both approaches give you the same information. The * 100 method shows 25 as a plain number; the percentage format shows 25%. Choose whichever matches how you plan to present the data.

Handling zero and negative original values

If your original value is zero, Excel displays #DIV/0! in that cell. This error means "division by zero," which is a real mathematical problem — you cannot calculate a meaningful percent increase when you're starting from nothing. There is no formula workaround for this; it's a genuine gap in your data.

If you have many rows with zero original values, you might add a note in your spreadsheet explaining that percent increase cannot be calculated for those rows. Alternatively, you can use an IF statement to check for zero first: =IF(A2=0,"N/A",((B2-A2)/A2)*100). This displays "N/A" instead of an error when the original value is zero.

Negative original values work mathematically, but the results can be confusing. If you started at -10 and ended at 10, the percent increase is 200%, which is technically correct but may not match how you think about the change. Check your data to make sure negative values make sense for what you're measuring.

Common mistakes and how to spot them

The most common mistake is reversing the order — writing =((A2-B2)/B2)*100 instead of =((B2-A2)/A2)*100. This gives you percent decrease instead of increase, shown as a negative number. If all your results are negative when you expected positive numbers, check whether you subtracted in the right direction.

Another mistake is forgetting to use cell references. If you type =((50-40)/40)*100 directly into a cell, it calculates correctly for those specific numbers, but you can't copy it down to other rows — it will give the same answer every time. Always use cell references like B2 and A2 so the formula adjusts for each row.

If your result looks too large or too small, double-check that you're using the right columns. A 25% increase should give you a number between 0 and 100 for most real-world data. If you see 2500 or 0.25, you've likely mixed up which column is original and which is new, or forgotten the * 100.

Frequently Asked Questions

What's the difference between percent increase and percent change?

Percent change is the same calculation and works in both directions — it can be positive (increase) or negative (decrease). Percent increase specifically means the value went up. If you want to measure both increases and decreases with one formula, use percent change. If you only care about increases, use percent increase and expect negative numbers to represent decreases.

Can I calculate percent increase for dates or text values?

No. The formula only works with numbers. If you try to use it on text or dates, Excel returns an error. Make sure your original and new values are stored as numbers, not text that looks like numbers. If a cell displays a number but the formula treats it as text, try reformatting the column as "Number" instead of "Text."

How do I show percent increase with one decimal place instead of many?

Right-click the cells with your results, choose "Format Cells," select "Number" from the category, and change the decimal places field to 1. Click OK. Excel will round your results to one decimal place — for example, 25.3% instead of 25.347%.

What if I want to calculate percent increase from a starting value to multiple ending values?

Put your starting value in one cell (say, A1), and put each ending value in a separate cell in column B. In column C, write =((B2-$A$1)/$A$1)*100. The dollar signs lock A1 in place, so when you copy the formula down, it always compares to A1 but changes which B cell it uses. This is called an absolute reference.