Find the average yearly growth rate between a start and end value.
Copy this formula
=(B2/A2)^(1/C2)-1Divide the ending value by the beginning value, raise it to 1 ÷ number of years, and subtract 1. CAGR smooths multi-year growth into a single annual rate. Format the result as a percentage.
=(2000/1000)^(1/3)-1→26%Doubling over 3 years ≈ 26%/yr.
RRI does it: =RRI(C2, A2, B2) returns the same rate from periods, present, and future values.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.