Formulas > =RRI()

How to Use RRI() in Google Sheets

Description

Returns the interest rate needed for an investment to reach a specific value within a given number of periods..

How To Actually Use RRI() in Sheets

RRI(number_of_periods, present_value, future_value)

Try RRI yourself

In cells A1 and A2, enter the number of periods and present value respectively. In cell A3, enter the future value. Use the RRI formula in cell A4 to calculate the required rate of return based on these values.

Hints (2)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Learn more about the RRI() formula:

Generate a RRI() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses RRI(). 2 free AI generations, no signup. Members get unlimited use.

Generate a RRI() formula