How to Calculate Growth Percentage in Excel

Whether you're tracking monthly revenue, measuring user growth, or comparing year-over-year performance, calculating growth percentage in Excel is one of the most practical skills in any analyst's toolkit. The good news: the math is straightforward. The nuance comes in knowing which formula fits your specific data structure.

The Core Formula for Growth Percentage

At its heart, growth percentage follows a simple structure:

Growth % = ((New Value – Old Value) / Old Value) × 100

In Excel, if your old value is in cell A1 and your new value is in B1, the formula looks like this:

=((B1-A1)/A1)*100 

This returns a raw percentage number. If you'd rather format the cell as a percentage (so Excel handles the ×100 automatically), use:

=(B1-A1)/A1 

Then format the cell as Percentage via the Number Format dropdown in the Home tab.

Calculating Growth Percentage Between Two Time Periods

The most common use case is comparing two adjacent periods — last month vs. this month, or last year vs. this year.

Negative results indicate decline, which is expected behavior — not an error.

Locking the Base Cell for Year-Over-Year Comparisons

If you're always comparing against a fixed starting point (like January of a fiscal year), use an absolute cell reference with the $ symbol:

=(B2-$B$1)/$B$1 

Drag this formula down the column and it will always divide by the original baseline value, not the previous row.

Compound Annual Growth Rate (CAGR) 📈

When you need to measure growth across multiple years — not just period-to-period — the right metric is CAGR (Compound Annual Growth Rate). This smooths out year-to-year fluctuations and shows the steady rate at which a value would have grown.

CAGR Formula:

=(End Value/Start Value)^(1/Number of Years)-1 

Example: If revenue grew from $50,000 to $89,000 over 5 years:

=(89000/50000)^(1/5)-1 

Format the result as a percentage and you get your annualized growth rate. This is commonly used in business reports, investment analysis, and performance reviews.

Handling Zeros and Negative Starting Values

This is where many users hit unexpected errors. If your old value is zero, dividing by it produces a #DIV/0! error — because dividing by zero is mathematically undefined.

Wrap your formula in an IFERROR function to handle this cleanly:

=IFERROR((B1-A1)/A1, "N/A") 

Negative base values are trickier. The formula will technically calculate, but the result can be misleading — a move from -100 to -50 would show as 50% "growth" even though losses halved. In these cases, many analysts use the absolute value of the denominator:

=(B1-A1)/ABS(A1) 

This is a workaround worth understanding rather than blindly applying — your specific context determines whether it makes analytical sense.

Displaying Growth Percentages Clearly

Formatting Options in Excel

• Percentage format: Home tab → Number group → % button (multiplies by 100 and adds the % symbol)
• Decimal control: Use the increase/decrease decimal buttons to show 20.00% vs. 20%
• Conditional formatting: Highlight positive growth in green and negative growth in red for quick visual scanning — found under Home → Conditional Formatting → Highlight Cell Rules

Using a Dedicated Column Structure

For ongoing tracking, a clean setup looks like this:

Keeping values and calculations in separate columns makes auditing and updating much easier than embedding everything in a single cell.

Variables That Affect Which Approach You Need 🔍

Not every growth percentage calculation looks the same. A few factors that shape the right method:

• Time horizon: Period-to-period growth vs. multi-year CAGR serve different analytical purposes
• Data structure: A single two-column comparison vs. a long time series calls for different formula strategies
• Negative or zero values in your dataset: These require error handling or formula adjustments
• What "growth" means in context: Unit sales growth, revenue growth, and user growth may each need different baseline logic
• Audience for the output: Internal analysis tolerates more complexity; a dashboard or report shared with non-technical stakeholders benefits from clean formatting and color-coding

Someone tracking a startup's monthly user acquisition works differently than a finance team modeling five-year revenue projections — even though both are technically calculating growth percentage.

The formula itself is universal. How you structure your spreadsheet, handle edge cases, and present the output depends entirely on what your data looks like and what decisions it needs to support.