Author: Oscar Cronquist Article last updated on July 01, 2022

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)

Arguments

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

Comments

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:

=(C4/C3)^(1/C2)-1

or

=(Fv/Pv)^(1/Nper)