RRI function
RRI returns the steady growth rate that takes a value from its start to its end over a number of periods. It works like CAGR for revenue or investments.
Example
Read it as a sentence: find the growth rate per period that takes 1000 to 2000 over 10 periods, which gives 0.071773463.
A
B
C
D
1
0.071773463
2
3
Syntax
RRI(nper, pv, fv)
-
nper(required) - Number of periods.
-
pv(required) - Starting value.
-
fv(required) - Ending value.
Returns: Equivalent growth rate per period.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=RRI(10,1000,2000) | 0.071773463 | 10 periods |
=RRI(10,2000,1000) | -0.066967008 | Fv < pv |
=RRI(2.5,100,150) | 0.176079023 | Fractional nper |
=RRI("10","1000","2000") | 0.071773463 | Text number |
=RRI({1,2},100,200) | 1 | Spill |
=RRI(0,1000,2000) | #NUM! | Nper 0 |
=RRI(-1,1000,2000) | #NUM! | Nper negative |
=RRI(10,0,2000) | #NUM! | Pv 0 |
Watch out for
- Equals (fv/pv)^(1/nper)-1; pv and fv must share a sign.
Where it works
- Excel
- RRI arrived in Excel 2013. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .