ProductSolutionsTemplatesResources

RRI

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

Video field
Financial

RRI function in Google Sheets is used to calculate the interest rate required for an investment to grow from the present value to the future value over a given number of periods.

The syntax of the RRI function is as follows:

RRI(numberofperiods, presentvalue, futurevalue)

Where:

numberofperiods: The number of periods over which the investment will grow. presentvalue: The present value of the investment. futurevalue: The future value of the investment.

The RRI function returns the interest rate required for the investment to grow from the present value to the future value over the given number of periods.

It is important to note that the RRI function assumes that the investment grows at a constant rate over the given periods, which may not always be the case in real-world scenarios.

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!