Excel RRI Function

Using the Excel RRI Function


The Excel RRI function returns an equivalent interest rate for the growth of an investment. RRI can be used to calculate the Compound Annual Growth Rate (CAGR).


=RRI (nper, pv, fv)

Syntax Breakdown

Required. Number of periods for the investment.

Required. Present value of the investment.

Required. Future value of the investment.

Usage Notes

RRI returns an interest rate given the number of periods, present value, and future value.

RRI Errors
The RRI function returns errors in the following instances:

1) #NUM! if argument values are not valid

2) #VALUE! if arguments are not using valid data types