RRI function

Category: Financial
Introduced: Excel 2013

Summary

Returns an equivalent interest rate for the growth of an investment

Syntax

RRI(nper, pv, fv) The RRI function syntax has the following arguments.
• Nper Required. Nper is the number of periods for the investment.
• Pv Required. Pv is the present value of the investment.
• Fv Required. Fv is the future value of the investment.
RRI returns the interest rate given nper (the number of periods), pv (present value), and fv (future value), calculated by using the following equation:

Example

=RRI(96,10000,11000)

Microsoft Support Page

https://support.microsoft.com/en-us/office/rri-function-6f5822d8-7ef1-4233-944c-79e8172930f4

Back to Functions