ExcelExcel 2013+
RRI function in Excel
Returns an equivalent interest rate for the growth of an investment
=RRI(nper, pv, fv)RRI syntax and parameters
Three arguments, three required.
- npernumberRequired
Nper is the number of periods for the investment.
- pvnumberRequired
Pv is the present value of the investment.
- fvnumberRequired
Fv is the future value of the investment.
RRI examples
Formulas you'll actually reuse.
The yearly rate that doubles $10,000 in 10 years — a CAGR:
=RRI(10, 10000, 20000)Result
0.0718Compound annual growth of revenue from B2 to C2 over five years:
=RRI(5, B2, C2)Result
0.1247
RRI in Google Sheets
Same name — your formula ports as-is.
Try RRI in the playground
Edit the example — nothing to install.
Preloaded with the RRI formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Excel gets this done.
- ACCRINTReturns the accrued interest for a security that pays periodic interestFinancialGoogle Sheets
- ACCRINTMReturns the accrued interest for a security that pays interest at maturityFinancialGoogle Sheets
- AMORDEGRCReturns the depreciation for each accounting period by using a depreciation coefficientFinancialNo Google Sheets equivalent
- AMORLINCReturns the depreciation for each accounting periodFinancialGoogle Sheets
- COUPDAYBSReturns the number of days from the beginning of the coupon period to the settlement dateFinancialGoogle Sheets
- COUPDAYSReturns the number of days in the coupon period that contains the settlement dateFinancialGoogle Sheets