RRI always returns the rate per period . If Nper is in years, the result is the annual compound interest rate.
=RRI(Nper, Pv, Fv)
Rate = (End Value / Start Value)^(1/Periods) - 1 rentes rente formel excel