To calculate growth rate in Excel, divide the change between the new and old values by the old value. If the old value is in A2 and the new value is in B2, enter =(B2-A2)/A2; format the result as a percentage to see the rate of increase or decrease.
The Basic Excel Growth Rate Formula
Growth rate is a relative change: it compares how much a value changed with the value it started from. Subtracting the old value from the new one gives the absolute change; dividing that difference by the old value expresses the change as a proportion of the starting point. The same calculation can be written as =B2/A2-1. With the same cell layout—old value in A2 and new value in B2—this alternative produces the same result.
For example, if A2 contains 80 and B2 contains 100, the change is 20, and 20 divided by 80 is 0.25. Displayed as a percentage, that is 25% growth. If B2 instead contains 70, the change is -10; divided by 80, the result is -0.125, or a 12.5% decline. A negative rate therefore signals a decrease, not an error.
Use the old value as the denominator when you want to know the percentage change from the starting value. Dividing by the new value answers a different question and will generally give a different percentage. For instance, moving from 80 to 100 is a 25% increase, while moving back from 100 to 80 is a 20% decrease. The amounts differ as percentages because each rate uses a different starting value.
Set Up the Worksheet
A simple table makes the calculation easy to audit and copy down. Put the earlier observation in one column and the later observation in the next. Use clear headings and consistent units, such as monthly revenue in dollars or monthly customer counts. The formula below assumes the first old value is in A2 and the matching new value is in B2.
- Enter a heading such as Old value in A1 and New value in B1.
- Enter the starting and ending values in A2 and B2.
- Enter the growth-rate formula in C2, where the result will appear.
- For more observations, keep each pair on its own row so each result compares matching periods.
In C2, with old values in A2 and new values in B2, enter =(B2-A2)/A2. Press Enter to calculate the result. To calculate later rows, select C2 and drag the small fill handle at its lower-right corner down the column. Excel adjusts the row references as it fills, so the next row compares A3 with B3, then A4 with B4, and so on. Check that the old and new values on each row refer to the same item and comparable periods.
If your data is arranged in rows by date rather than in old/new columns, the same principle applies: compare each value with the previous period. For example, when January is in B2 and February is in C2, the next-period calculation belongs in C3 only if the layout is deliberately organized that way; avoid copying formulas across or down without checking which cells they reference. A well-labeled layout reduces the chance of comparing the wrong periods.
Show the Result as a Percentage
Excel stores the calculated rate as a decimal. A result of 0.25 represents 25%, and -0.125 represents -12.5%. To make the result readable, select the result cell or range and choose Home > Number > Percent Style. This changes how Excel displays the value; it does not change the underlying calculation.
After applying percentage formatting, adjust the number of decimal places if useful. A whole percentage may be clear for a high-level summary, while one or two decimal places can help when comparing small changes. For example, 0.014 displays as 1% with no decimal places and 1.4% with one. Avoid showing more precision than the data supports: a rate calculated from rough estimates can look falsely exact if it is displayed to many decimal places.
Do not multiply the formula by 100 if you also plan to use percentage formatting. That would turn a rate of 0.25 into 25 and then display it as 2,500%. Choose either a decimal result with percentage formatting, which is usually best, or a numeric value already multiplied by 100 displayed as an ordinary number.
Calculate Growth Across Several Periods
For a time series, calculate each period’s rate against the immediately preceding period. Suppose monthly values are in B2:B5, with January in B2 and February through April in B3:B5. The February-to-January rate goes in C3, the March-to-February rate in C4, and the April-to-March rate in C5. In C3, with January’s value in B2 and February’s in B3, enter =(B3-B2)/B2. Copy it down to C5; Excel will update the references for each adjacent pair.
This is period-over-period growth. It answers how quickly the value changed from one observation to the next, not how much it changed over the entire series. To calculate the total change from January through April, use the January and April values as the endpoints. With January in B2 and April in B5, enter =(B5-B2)/B2. If the result is 50%, the ending value is 50% higher than the starting value across the full span, even if individual months rose and fell along the way.
Make sure periods have equal lengths before comparing their rates. A monthly rate and a quarterly rate are not directly comparable just because both are formatted as percentages. Also check for missing periods: if one row is skipped, a formula comparing adjacent rows may measure two months of change while appearing to show one-month growth.
Calculate Annualized Growth Rate or CAGR
When values span multiple years, a compound annual growth rate (CAGR) expresses the overall change as a smoothed annual rate. It answers this question: what constant annual rate would take the starting value to the ending value over the stated number of years? CAGR is not the actual rate in every year; it summarizes the endpoints and duration.
For a beginning value in A2, ending value in B2, and number of years in C2, enter =(B2/A2)^(1/C2)-1. For example, if A2 is 100, B2 is 150, and C2 is 3, the result is approximately 0.1447, or 14.47% per year. The arithmetic checks because 100 multiplied by 1.1447 three times is approximately 150. Format the formula result as a percentage.
Use the number of elapsed years, not automatically the number of observations. If annual measurements are labeled 2021, 2022, 2023, and 2024, the first-to-last interval is three years, even though there are four data points. For a period shorter or longer than a whole number of years, use a duration expressed consistently in years. CAGR is useful for comparing long-term growth over different spans, but it conceals fluctuations between the endpoints and can be misleading if either endpoint is unusual.
Choose the Right Growth Measure
Use a standard percentage change for a single before-and-after comparison. Use period-over-period rates when you need to see changes across a timeline. Use CAGR when you want one annualized summary for a multi-year interval. These measures are related, but they answer different questions, so label the result with its time period and method.
A simple average of several percentage rates is not necessarily the overall growth rate. Consider a value that rises 50% in one period and then falls 50% in the next. The arithmetic average of those two rates is zero, but a starting value of 100 becomes 150 and then 75. The ending value is 25% below the starting value. Compounding matters because each period’s rate applies to the value at the start of that period, not always to the original value.
For a total-period comparison, calculate the change from the first value to the last. For a smoothed annual comparison over several years, calculate CAGR. An arithmetic average can still be useful for summarizing a set of rates for a specific purpose, but it should not be presented as the compounded growth of the underlying values unless that interpretation is justified.
Excel also has a function named GROWTH, but it serves a different purpose: it estimates values along an exponential trend from known data. It is not simply another name for the percentage-change calculation. For ordinary growth between two known values, the direct formula is clearer; use trend-estimation tools only when your question is about modeling or predicting a pattern.
Common Errors and How to Handle Them
- Starting value is zero: Percentage change from zero is undefined because the calculation divides by the starting value. Excel returns a division-by-zero error. Report the absolute increase, or describe the change as beginning from zero, rather than presenting a conventional percentage rate.
- Starting value is negative: The arithmetic may return a number, but interpreting it as growth can be confusing. This often occurs with losses, debt, or other signed measures. Explain the direction and context instead of relying on the percentage alone.
- Values are stored as text: Numbers imported with unusual symbols or spaces may not calculate as expected. Check that the cells contain numeric values and that decimal and thousands separators match the workbook’s regional settings.
- Wrong denominator: Dividing by the new value calculates a different ratio. Keep the old value as the denominator when measuring percentage change from the old value.
- Comparing inconsistent periods: A rate from a short interval should not be compared uncritically with one from a longer interval. Confirm that the dates, units, and observation intervals are comparable.
- Too many displayed decimals: Formatting changes display, not accuracy. Choose decimal places that suit the source data and the decision the comparison supports.
If a formula returns an error, inspect the referenced cells before replacing the error with a blank. In particular, a blank or zero old value can make the rate undefined or misleading. Error-handling functions can hide a problem without resolving it, so decide what an undefined rate should mean for the worksheet before building a report around it.
Frequently Asked Questions
What is the formula for percentage growth in Excel?
Divide the difference between the new and old values by the old value. With the old value in A2 and the new value in B2, use =(B2-A2)/A2 and format the result as a percentage.
How do I calculate growth when the value decreases?
Use the same formula. If the new value is lower than the old value, the result is negative, which represents a decline. For example, a change from 80 to 70 is -12.5% relative to the starting value.
Why does my growth rate formula return #DIV/0!?
The formula is dividing by a zero or blank starting value. A percentage change from zero is undefined. Check whether the reference is correct; if the starting value really is zero, report the absolute change or explain the situation rather than forcing a percentage.
How do I calculate annual growth over several years?
Use CAGR when you want one smoothed annual rate from the first and last values. Divide the ending value by the beginning value, raise that ratio to the power of one divided by the number of elapsed years, then subtract one. It summarizes the interval and does not show the actual rate in each year.
Should I average yearly growth rates to find total growth?
Usually not. Rates compound, so their arithmetic average may not match the change in the underlying values. Compare the first and last values for total growth, or use CAGR for an annualized summary across the interval.
Related
- Excel Max Value in a Column: Find the Largest Number
- Excel Maximum Rows: Limits and What to Do
- Excel Max Row Count: How Many Rows Can a Sheet Hold?
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- IF Function in Excel: Examples and Practical UsesIn Excel, the IF function checks whether a condition is true and returns one result if it is,…
- VLOOKUP Excel: Extended Uses, Examples, and LimitsVLOOKUP can do more than retrieve one value from a simple list: it can use exact or approximate…
- Excel Slicer Custom Sort Order: How to Set ItTo give an Excel slicer a custom order, create an Excel custom list containing the slicer items in…
- INDEX and VLOOKUP in Excel: How They Work and CompareINDEX and VLOOKUP are both Excel lookup tools: VLOOKUP searches the leftmost column of a range and returns…
- Excel Sum Whole Column: Formulas, Examples, and TipsTo sum every numeric value in an Excel column, enter =SUM(A:A) in a cell outside column A and…
- IFERROR vs ISERROR: Which Excel Function Should You Use?IFERROR catches an error produced by a calculation and returns a replacement value; ISERROR checks whether a value…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.