RRI Function
Returns the equivalent steady growth rate between a start and end value.
Category
Financial
Available in
Excel 2013+, Microsoft 365
Returns
A growth rate per period
Want to practice RRI in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
RRI calculates compound annual growth rate (CAGR): the constant rate that turns a starting value into an ending value over a number of periods.
It equals (end ÷ start)^(1 ÷ periods) − 1.
Syntax
=RRI(nper, pv, fv) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| nper | Yes | The number of periods. |
| pv | Yes | The starting value. |
| fv | Yes | The ending value. |
Examples
Example 1 — Revenue CAGR
Northstar's revenue grew from $2.4M to $3.6M over four years.
B4fx=RRI(B3,B1,B2)
| A | B | |
|---|---|---|
| 1 | Start revenue | $2,400,000 |
| 2 | End revenue | $3,600,000 |
| 3 | Years | 4 |
| 4 | CAGR | 10.67% |
Growing 10.67% every year for four years gets from $2.4M to $3.6M — even if the real years were bumpy.
Common mistakes
- #NUM! error. nper must be positive, and pv and fv need the same sign.
Notes
- Related functions: RATE, PDURATION, FVSCHEDULE.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.