RRI function has been introduced with Excel 2013. It returns the interest rate for the growth of an given investment based on it's present value and future value for a given period.
For example, to know what would be the interest rate for an intitial investment of Rs.1000 to become double i.e, Rs.2000 in 5 years, we can use RRI formula as
=RRI(nper, pv, fv)
nper is the number of periods for the investment
Pv is the present value of the investment
Fv is the future value of the investment
Note:- If you enter any non-numbers in above arguments, you'll get #VALUE! error.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.