The basic formula for growth percentage

To calculate growth percentage in Excel, subtract the starting value from the ending value, divide by the starting value, then multiply by 100. The formula is: =((Ending Value - Starting Value) / Starting Value) * 100

If your starting value is in cell A1 and your ending value is in cell B1, you would write =((B1-A1)/A1)*100 in an empty cell. Excel will return the percentage change between those two numbers. A positive result means growth; a negative result means decline.

For example, if a product cost $50 last year (A1) and costs $65 this year (B1), the formula returns 30, meaning a 30 percent increase. If the price dropped to $40, the formula returns -20, meaning a 20 percent decrease.

Key Takeaways

  • The growth percentage formula divides the change in value by the original value and multiplies by 100: =((New-Old)/Old)*100
  • You can remove the *100 and format the cell as a percentage to get the same result without manually typing the multiplication.
  • For multiple rows of data, enter the formula once and drag it down to calculate growth for each row automatically.
  • Absolute references (using $ signs) let you compare all values to a single starting point, like comparing sales in each month to January.

Removing the multiplication by 100 with percentage formatting

You do not have to multiply by 100 in your formula if you format the result as a percentage. Write =((B1-A1)/A1) instead, then right-click the cell and select Format Cells. Choose Percentage from the Category list and click OK.

Excel will automatically display the decimal result as a percentage. A result of 0.30 becomes 30%, and -0.20 becomes -20%. This method is cleaner because you can adjust decimal places without editing the formula itself. Right-click the cell again, select Format Cells, and change the number of decimal places under the Percentage category.

Calculating growth for multiple rows at once

If you have a column of starting values and a column of ending values, you can calculate growth for all rows without retyping the formula. Enter the formula =((B2-A2)/A2)*100 in cell C2 (or whichever column you want the result in). The row numbers (2, 2) will adjust automatically when you copy the formula down.

Click cell C2 to select it. Move your cursor to the small square in the bottom-right corner of the cell until it becomes a plus sign, then click and drag down to the last row of data. Excel copies the formula to each row and updates the cell references automatically. Row 3 becomes =((B3-A3)/A3)*100, row 4 becomes =((B4-A4)/A4)*100, and so on.

Using absolute references to compare against one starting point

Sometimes you want to measure growth from a single baseline value rather than comparing each row to its own starting point. Use absolute references by adding dollar signs ($) around the cell you want to stay fixed. The formula =((B2-$A$1)/($A$1))*100 always divides by the value in A1, no matter which row you copy it to.

This is useful when tracking monthly sales growth from January, or comparing quarterly revenue to a baseline year. Enter the formula in your first data row, then drag it down. Every calculation will subtract and divide by the same starting value (A1 in this example), while the ending values (B2, B3, B4) change with each row.

Handling negative starting values and zero

If your starting value is negative, the formula still works mathematically, but the result can be confusing. A change from -10 to 10 returns 200 percent, which is technically correct but may not match how you think about the growth. Consider whether the context makes sense before using the standard formula with negative numbers.

If your starting value is zero, Excel will return a #DIV/0! error because you cannot divide by zero. You can prevent this error by using an IF statement: =IF(A1=0,"N/A",((B1-A1)/A1)*100). This formula displays "N/A" when the starting value is zero instead of showing an error.

Comparing growth rates across different time periods

Growth percentage works the same way whether you are measuring change over one month, one year, or five years. The formula does not care about the time span—it only measures the percentage change between two values. If you want to compare growth rates fairly across different time periods, you need to calculate the growth per unit of time (like annual growth rate).

For annual growth rate over multiple years, use the compound annual growth rate (CAGR) formula: =((Ending Value/Starting Value)^(1/Number of Years))-1. In Excel, this looks like =((B1/A1)^(1/5))-1 for five years of growth. Multiply by 100 if you want the result as a percentage. This accounts for the fact that growth compounds over time and gives you a more accurate year-by-year comparison.

Frequently Asked Questions

What is the difference between growth percentage and percentage change?

They are the same thing. Growth percentage and percentage change both measure how much a value has increased or decreased relative to its starting point. The formula and result are identical.

Why does my formula show a decimal instead of a percentage?

If you used the formula without multiplying by 100, the result is a decimal. Format the cell as a percentage (right-click, Format Cells, Percentage) and Excel will display it as a percentage automatically. Or multiply by 100 in your formula to see the number directly.

Can I calculate growth percentage for negative numbers?

Yes, the formula works with negative numbers, but the result may not match your expectations. A change from -50 to -30 returns 40 percent, which is mathematically correct but represents a decrease in absolute value. Test the formula with your data to make sure the result makes sense for your situation.

How do I calculate average growth percentage across multiple values?

Calculate the growth percentage for each row separately using the standard formula, then use the AVERAGE function on those results: =AVERAGE(C2:C10) if your growth percentages are in cells C2 through C10. This gives you the mean growth rate across all the rows.