Functions
RRI
Equivalent interest rate for growth
Try it
When to use it
When should I use RRI?
Use RRI to find the equivalent per-period interest rate needed for an investment to grow from a present value to a future value over a given number of periods — useful for comparing growth rates across different time horizons.
Used in
Syntax
RRI(nper, pv, fv)Examples
=RRI(10.5,10,3) // => -0.10833437505113597
=RRI(3,2,4) // => 0.2599210498948732
=RRI(1,10,0) // => -1