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

ArgumentRequired?What it does
nperYesThe number of periods.
pvYesThe starting value.
fvYesThe 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)
AB
1Start revenue$2,400,000
2End revenue$3,600,000
3Years4
4CAGR10.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

Kyle Stott

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.