Check Sheet Logo
Check Sheet


The RRI function calculates the interest rate per period of an investment based on the number of periods, present value, and future value. It is commonly used to determine the rate of return on an investment.


Use the RRI formula with the syntax shown below, it has 3 required parameters:

=RRI(number_of_periods, present_value, future_value)
  1. number_of_periods (required):
    The total number of investment periods.
  2. present_value (required):
    The present value of the investment.
  3. future_value (required):
    The future value of the investment.


Here are a few example use cases that explain how to use the RRI formula in Google Sheets.

Calculating rate of return

Use RRI to calculate the rate of return on an investment based on the present and future values.

Comparing investments

Use RRI to compare the rates of return on different investments with different present and future values.

Common Mistakes

RRI not working? Here are some common mistakes people make when using the RRI Google Sheets Formula:

Not providing all three arguments

The RRI function requires three arguments: the number of periods, the present value, and the future value. Leaving out any of these arguments will result in an error.

Providing non-numeric arguments

All arguments for the RRI function must be numeric. Providing non-numeric arguments will result in an error. Make sure that all arguments are numbers or refer to cells that contain numbers.

Present value is greater than future value

The present value argument must be less than the future value argument for the RRI function to return a valid result. If the present value is greater than the future value, the function will return an error.

The following functions are similar to RRI or are often used with it in a formula:

  • PV

    The PV function in Google Sheets calculates the present value of a regular payment stream or a lump sum amount, based on a constant interest rate. It is commonly used in financial analysis to determine the value of investments or loans. This function returns a negative value, as it represents money flowing out from the user.

  • FV

    The FV function calculates the future value of an investment based on periodic constant payments and a constant interest rate. It takes into account the present value of the investment, the number of periods in which the payments are made, and the compounding frequency. This formula is commonly used in financial planning and investment analysis.

  • NPV

    The NPV function calculates the net present value of a series of cash flows, discounted by a specified rate. It is commonly used to determine the present value of an investment, where the cash flows represent incoming and outgoing payments. The function takes a discount rate and one or more cash flow values as input.

Learn More

You can learn more about the RRI Google Sheets function on Google Support.