RRI Function in Excel: Syntax, Examples and Free Practice
RRI is an Excel Financial function. Returns an equivalent interest rate for the growth of an investment.
RRI syntax
Arguments
nper: The total number of payment periodspv: The present value of the amountfv: The future value of the amount
When to use RRI
RRI is used in loan, investment, or valuation models where precise financial math is required.
Practice RRI online, free
Open the live Excel-style spreadsheet and try RRI yourself. No Excel install or sign-up needed to start.
Practice RRI now →More Financial functions
Frequently asked questions
What does the RRI function do in Excel?
Returns an equivalent interest rate for the growth of an investment.
What is the syntax of RRI in Excel?
The syntax is =RRI(nper, pv, fv). nper: The total number of payment periods; pv: The present value of the amount; fv: The future value of the amount.
Where can I practice RRI online for free?
Open the free live spreadsheet on Cellgrids and try RRI yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Financial functions · Excel case studies · Excel tutorials · Excel shortcuts