Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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 .