Author: Oscar Cronquist Article last updated on April 15, 2019

The RRI function calculates the growth of an investment in percent per period.

Formula in cell C6:

=RRI(C2, C3, C4)

Excel Function Syntax

RRI(Nper, Pv, Fv)


Nper Required. Nper is the number of periods.
Pv Required. Pv is the present value.
Fv Required. Fv is the future value.


The YIELD function returns:

  • #VALUE! error if arguments are not a valid data type.
  • #NUM! error if the arguments are not valid.

The equivalent formula is: