RRI function

The RRI function returns the interest rate needed for an investment to reach a specific value within a given number of periods.

Parts of a RRI function

RRI(number_of_periods, present_value, future_value)

Part Description
number_of_periods Required. The number of periods.
present_value Required. The present value of the investment
future_value Required. The future value of the investment.


  • All values must be positive. Number_of_periods and present_value must be greater than 0.
  • If future_value is 0, the rate returned is -1 (-100%).


RRI Formula
-0.1083343751 =RRI(10.5, 10, 3)
0.2599210499 =RRI(3, 2, 4)
-1 =RRI(1, 10, 0)

Related functions

  • PDURATION: The PDURATION function returns the number of periods for an investment to reach a specific value at a given rate.
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Clear search
Close search
Google apps
Main menu