The Basic Formula for Growth Percentage

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

In a spreadsheet, this looks like =(C2-B2)/B2*100 if your starting value is in column B and ending value is in column C. Excel will return a number like 25, meaning 25 percent growth. You can also format the result as a percentage by selecting the cell, right-clicking, choosing "Format Cells", and selecting "Percentage" — Excel will then display it as 25% without you needing to multiply by 100 in the formula.

Key Takeaways

  • The growth percentage formula divides the change by the original amount: ((New - Old) / Old) * 100.
  • You can write this as a single formula in one cell or break it into separate columns to see each step clearly.
  • Negative growth percentages show decline; a result of -20 means the value dropped by 20 percent.
  • Excel's percentage formatting automatically multiplies by 100, so you can omit the *100 from your formula if you format the cell as a percentage.
  • The formula works for any values: revenue, website traffic, inventory, or any metric that changes over time.

Setting Up Your Data in Columns

Organize your data so the starting value and ending value sit in separate columns. For example, put the month or item name in column A, the starting value in column B, and the ending value in column C. This layout makes the formula easier to read and lets you copy it down to calculate growth for multiple rows at once.

If you are tracking monthly revenue, your spreadsheet might look like this: January in A1, $5,000 in B1, $6,200 in C1. Then in cell D1, you would enter the growth formula. Once you type the formula in D1, you can click the small square at the bottom-right corner of the cell and drag it down to explore the same formula to all rows below — Excel automatically adjusts the cell references for each row.

Using Absolute and Relative References

When you copy a formula down multiple rows, Excel normally changes the cell references automatically. If your formula in D1 is =(C1-B1)/B1*100, copying it to D2 changes it to =(C2-B2)/B2*100, which is what you want. This is called a relative reference.

Sometimes you need a reference to stay the same when you copy the formula. For example, if you want to compare all values to a single baseline year, you would use an absolute reference by adding dollar signs: =(C2-$B$1)/$B$1*100. The $B$1 stays locked on cell B1 even when you copy the formula down. Use absolute references only when you have a specific reason — most growth calculations use relative references.

Calculating Compound Annual Growth Rate (CAGR)

If you need to find the average growth rate over multiple years, use the compound annual growth rate formula instead. CAGR shows what percentage something grew per year on average, smoothing out year-to-year ups and downs. The formula is: =(Ending Value / Starting Value) ^ (1 / Number of Years) - 1.

In Excel, this looks like =(C5/B1)^(1/4)-1 if your starting value is in B1, ending value is in C5, and you have 4 years of data. The ^ symbol means "to the power of". Format the result as a percentage to see it clearly. CAGR is useful for comparing investment returns or long-term business growth where year-to-year changes vary widely.

Handling Negative Numbers and Declining Values

When a value decreases instead of increases, the formula still works — it straightforward returns a negative percentage. If revenue dropped from $10,000 to $7,000, the formula =(7000-10000)/10000*100 returns -30, meaning a 30 percent decline.

Be careful interpreting negative growth. A -50 percent change is not the same as a 50 percent recovery. If something drops 50 percent, it would need to grow 100 percent to return to its original value. When you are working with values that fluctuate between positive and negative, or when you need to compare growth rates across items with very different starting values, consider whether a straightforward percentage is the right metric or whether you need a different approach.

Common Mistakes to Avoid

The most common error is dividing by the ending value instead of the starting value. The formula must use the original amount as the denominator — that is what makes the percentage meaningful. Dividing by the new value gives you a completely different (and wrong) number.

Another mistake is forgetting to multiply by 100 when you do not format the cell as a percentage. If you write =(C2-B2)/B2 without the *100, Excel returns 0.25 instead of 25. The number is correct mathematically, but it does not look like a percentage. Either multiply by 100 in the formula or format the cell as a percentage — do not do both, or you will get 2500 instead of 25.

Watch out also for zero or negative starting values. If your starting value is zero, the formula returns an error because you cannot divide by zero. If your starting value is negative and your ending value is positive, the percentage change can look misleadingly large. In these cases, you may need to note the limitation or use a different metric.

Formatting and Displaying Results Clearly

After you calculate growth percentage, format the cells so the numbers are straightforward to read. Select the cells with your results, right-click, and choose "Format Cells". Under the "Number" tab, select "Percentage" and choose how many decimal places you want to show. Most growth calculations look clearest with one or two decimal places — 15.3% rather than 15.27% or 15%.

You can also add conditional formatting to highlight results visually. Select your growth percentage cells, go to the "Home" tab, click "Conditional Formatting", and choose a rule like "Color Scales" or "Data Bar". This lets you see at a glance which items grew fastest and which declined. Green for positive growth and red for negative growth is a common choice, though you can customize the colors.

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 something changed relative to where it started. The formula is identical: ((New - Old) / Old) * 100. The term "growth" is often used when the value increased, and "change" when it could go either direction, but the math is the same.

Can I calculate growth percentage if I only have the percentage change, not the actual numbers?

No. You need both the starting and ending values to calculate growth percentage. If someone tells you "revenue grew 20 percent" but does not give you the actual dollar amounts, you cannot work backward to find the original revenue. You would need at least one of the actual values to find the other.

How do I show growth percentage as a decimal instead of a whole number?

Use the formula without multiplying by 100: =(C2-B2)/B2. Then format the cell as a decimal with the number of places you want. A result of 0.25 means 25 percent. This is useful when you are doing further calculations with the growth rate, because Excel treats 0.25 as the actual decimal value rather than the number 25.

What if my starting value is negative?

The formula still works mathematically, but the result can be misleading. If you start at -$100 and end at $100, the formula returns 200 percent growth, which is technically correct but does not tell the full story. When starting values are negative, consider adding a note explaining the context or using a different metric like absolute change in dollars.

Can I use this formula to compare growth across different time periods?

Yes, as long as the time periods are the same length. If you calculate monthly growth for each month, you can compare them directly. If you compare a 3-month period to a 12-month period, the percentages are not directly comparable because they cover different amounts of time. For unequal time periods, use compound annual growth rate (CAGR) instead.