Returns the equivalent interest rate for the growth of an investment.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
RRI(nper, pv, fv)The RRI function calculates the interest rate required for an investment to grow from a beginning value to a future value over a specified number of periods. It is useful for determining the annual or periodic yield needed to reach a specific financial goal.
=RRI(5, 1000, 1500)Result: 0.08447
Calculates the interest rate required for 1,000 to grow to 1,500 over 5 periods.
The function will return the #NUM! error if nper <= 0 or if pv and fv are not greater than zero.