How to Calculate Annual Growth Rate in Excel (Without the Headache)

It is 11:45 PM. You are staring at a spreadsheet that looks like an abstract art project made of random numbers, trying to figure out how much your business revenue—or your investment portfolio, or your website traffic—actually grew over the last few years.

You type "calculate annual growth rate in Excel" into a search engine because you know the tool can do it in a split second, if only you could remember whether it is =(B2-A2)/A2 or =(A2/B2)^(1/5)-1 or some other mystical combination of parentheses and capital letters that always seems to return a #VALUE! error right when your patience is running on empty.

Take a breath. Close the tab with the confusing forum posts from 2012. You do not need a degree in data science to make Excel do this math for you. You just need a clear map of what you are actually trying to measure, and the exact, copy-pasteable formulas to get you there.

By the time you finish reading this, you will have two reliable tools in your belt: one for simple year-on-year growth, and one for the powerful Compound Annual Growth Rate (CAGR) that smooths out all the messy ups and downs.

---

The Two Types of Growth (And Why Choosing the Wrong One Ruins Your Math)

Before we touch a single cell in Excel, we have to talk about what "growth" actually means in your specific situation. Because if you use the wrong formula, you are going to misread your own data—and that is a dangerous game when you are trying to make financial decisions.

Imagine you started a side hustle selling handmade leather bags.

• In Year 1, you made $10,000.
• In Year 2, you made $15,000.
• In Year 3, you made $22,000.

If you just look at Year 1 to Year 2, your business grew by 50%. That is simple percentage change. It is great for looking at what happened between two specific points in time.

But what if you want to know how fast your business grew on average every year across the entire three-year span? If you just average 50% and whatever the next year's jump was, you will get a distorted picture because of compounding—the way growth builds on top of previous growth.

This is where people get tripped up. They treat a multi-year trend like a single-year jump, or vice versa.

• Use Simple Annual Growth Rate when you are comparing just two years (this year versus last year).
• Use Compound Annual Growth Rate (CAGR) when you are measuring growth across three or more years and want to smooth out the bumpy ride in between.

Let’s look at how to build both in Excel, step by step, using a running example we can both follow.

---

Method 1: The Simple Year-Over-Year Growth Rate

Let’s say you are looking at your annual salary, your rental property income, or your portfolio value between just two points in time. You want to know the straightforward percentage increase from point A to point B.

Here is our scenario. Meet Sarah. Sarah started her freelance graphic design business and tracked her revenue over two consecutive years:

• 2022 Revenue (Cell A2): $40,000
• 2023 Revenue (Cell B2): $50,000

Sarah wants to know her annual growth rate.

The Logic Behind the Math

To find a percentage increase, you need to know two things: the difference between the two numbers, and what you are comparing that difference against (the starting point).

1. Subtract the old value from the new value ($50,000 - $40,000 = $10,000 increase).
2. Divide that increase by the original starting value ($10,000 ÷ $40,000 = 0.25).
3. Convert that decimal to a percentage (0.25 × 100 = 25%).

How to Write It in Excel

In Excel, you don't need to multiply by 100 manually; you just format the cell as a percentage.

If your old value is in cell A2 and your new value is in cell B2, click into cell C2 and type this exact formula:

=(B2-A2)/A2

Hit Enter, and you will see 0.25. Now, click the Percent Style button on the Home ribbon (it looks like %), and that number transforms into a clean, readable 25%.

What Trips People Up: The Parentheses Trap

The single most common mistake people make with this formula is forgetting the parentheses around (B2-A2).

If you type =B2-A2/A2 without parentheses, Excel follows the mathematical order of operations (PEMDAS/BODMAS). It will divide A2 by A2 first (which equals 1), and then subtract that from B2. Your $40,000-to-$50,000 growth will suddenly look like $49,999.

Always wrap your subtraction in parentheses. Excel needs to calculate the total difference before it divides by the starting base.

---

Method 2: The Multi-Year Monster (CAGR)

Simple year-over-year growth works fine when you are only looking at two years. But what happens when you have a timeline that spans half a decade, and your numbers look like a roller coaster?

Let’s stick with Sarah. Fast forward a few years, and her business has grown substantially. Here is her multi-year tracking sheet:

• 2018 Revenue (Starting Year): $40,000 (Cell A2)
• 2023 Revenue (Ending Year): $95,300 (Cell B2)

Sarah wants to know her Compound Annual Growth Rate over that 5-year period. She wants to know what constant, steady annual growth rate would take her from $40,000 to $95,300 if every year grew at the exact same pace.

The Formula Everyone Forgets

The mathematical formula for CAGR looks intimidating:

$$\text{CAGR} = \left( \frac{\text{Ending Value}}{\text{Beginning Value}} \right)^{\frac{1}{n}} - 1$$

Where $n$ is the number of years.

Translate that into Excel-speak, and it feels like trying to program a microwave with your toes. But once you break it down into cell references, it becomes remarkably straightforward.

How to Write It in Excel

Assuming:

• A2 contains your Starting Value ($40,000)
• B2 contains your Ending Value ($95,300)
• C2 contains the number of years between them (5)

Click into your result cell and type:

=(B2/A2)^(1/C2)-1

Hit Enter, format the cell as a percentage, and boom: 18.96%.

That means, on average, Sarah's business grew by roughly 18.96% every single year for five years, compounding on top of itself to reach that final $95,300 total.

The Hidden Trap: Counting Years vs. Counting Rows

This is where 90% of people mess up CAGR in Excel, leading to wildly inaccurate numbers that can throw off financial projections.

Look at your spreadsheet columns or rows.

• Year 1: $40,000
• Year 2: $48,000
• Year 3: $57,600
• Year 4: $69,120
• Year 5: $82,944

If you count the data points, you see five rows of numbers. If you put 5 as your number of years (n), you will get the wrong answer.

Why? Because growth happens between points in time, not at the points themselves.

• From Year 1 to Year 2 is 1 year.
• From Year 2 to Year 3 is 2 years.
• From Year 3 to Year 4 is 3 years.
• From Year 4 to Year 5 is 4 years.

To find n correctly, you take your final year minus your starting year ($5 - 1 = 4$ years of growth). Alternatively, if you are counting rows in Excel, the number of periods is always the total number of rows minus one.

Always double-check your time span. If your data covers a 10-year period, your n is 10. If you are measuring from January 2020 to January 2021, your n is 1. Do not let Excel count the data entries for you; count the actual elapsed time loops.

---

Method 3: Using Excel’s Built-In RRI Function (The Shortcut)

If looking at exponents like ^(1/C2) gives you flashbacks to high school algebra class, Excel has a hidden backdoor function built specifically for this. It is called RRI, which stands for Rate of Return.

It does the exact same thing as our complex CAGR formula, but with cleaner syntax.

Using the same numbers (Start Value in A2, End Value in B2, Number of Years in C2), you can type this into any cell:

=RRI(C2, A2, B2)

Look at that order: Periods, Present Value (Start), Future Value (End).

Hit Enter, format as a percentage, and you get the exact same 18.96%.

Why doesn't everyone use RRI? Because older versions of Excel or alternative spreadsheet programs (like some legacy desktop software) occasionally prefer the manual exponent method for compatibility. But if you are using modern Excel or Google Sheets, RRI is a fantastic, readable shortcut that keeps your formulas looking clean and professional.

---

When Your Numbers Go Negative (And Excel Breaks)

Life is messy. Investments drop. Business revenues dip during a bad quarter or a global supply chain crunch. And when negative numbers enter your growth calculations, Excel’s formulas can start throwing tantrums.

Imagine Sarah has a rough year.

• Year 1: $50,000
• Year 2: $30,000 (A drop)

Let's plug that into our simple growth formula =(B2-A2)/A2: =(30000 - 50000) / 50000 = -20000 / 50000 = -0.40 or -40%.

Excel handles a single negative drop just fine.

The Real Problem: Starting at Zero or Negative

Where Excel completely falls apart is when your starting value is zero or negative.

Suppose Sarah launches a brand-new project.

• Year 1 Revenue: $0
• Year 2 Revenue: $10,000

If you try to run =(10000 - 0) / 0, Excel will instantly throw a #DIV/0! error. You cannot divide by zero in mathematics—it creates an infinite loop that breaks the rules of arithmetic.

How to handle it: If your starting value is zero, you cannot calculate a standard percentage growth rate. The math simply doesn't allow it, because going from nothing to something is technically an infinite percentage increase.

Instead of showing a broken error cell in your report, use an IF statement to handle the exception gracefully:

=IF(A2=0, "N/A", (B2-A2)/A2)

This tells Excel: If the starting cell is zero, just print "N/A" so my boss or my accountant doesn't think the spreadsheet is broken. Otherwise, run the normal growth formula.

It is a small touch, but it turns a messy, unprofessional error screen into a clean, readable report.

---

Bringing It All Together: A Complete Financial Health Check

Let’s step back and look at what you’ve built.

You no longer have to guess whether your multi-year project is actually moving forward or just spinning its wheels.

• If you are looking at year-over-year progress, =(New-Old)/Old gives you the exact snapshot you need.
• If you are mapping a long-term trajectory, =(End/Start)^(1/Years)-1 (or =RRI(Years, Start, End)) smooths out the noise and gives you your true compound growth rate.
• And you know to watch out for the parentheses trap and the zero-division error before they ruin your late-night workflow.

The numbers are no longer a black box. They are just data points telling a story—and now, you know how to read the last page.

---

Frequently Asked Questions

Can I use these exact same formulas in Google Sheets?

Yes. Both the simple percentage formula =(B2-A2)/A2, the CAGR exponent formula =(B2/A2)^(1/C2)-1, and the RRI function work identically in Google Sheets. You don't need to learn a separate set of commands if you switch between platforms.

What is the difference between CAGR and Average Annual Growth Rate (AAGR)?

CAGR (Compound Annual Growth Rate) assumes your growth compounds year-over-year, flattening out the bumpy ride to show a steady geometric progression. AAGR (Average Annual Growth Rate) simply averages the percentage growth of each individual year without taking compounding into account. Financial professionals almost always prefer CAGR for investments and multi-year business tracking because it reflects the true reality of how money and assets grow over time.

How do I calculate growth rate if my data is monthly instead of yearly?

The math is structurally identical, but your time period (n) changes. If you are measuring growth across 24 months, your n is 24, and your result will be a monthly growth rate. If you want to annualize that monthly growth rate into an annual figure, you apply a compounding adjustment: (1 + Monthly Rate)^12 - 1.

---

Disclaimer: The formulas and examples provided above are for general informational and educational purposes. Always double-check your critical financial calculations before making major business or investment decisions.

Want to run these numbers on the go? Open up the free Finlaa app to test your scenarios without needing a desktop spreadsheet open.