WorksheetFunction.Rri method (Excel)
Returns an equivalent interest rate for the growth of an investment.
expression.Rri (Arg1, Arg2, Arg3)
expression A variable that represents a WorksheetFunction object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Arg1 | Required | Double | Number of periods for the investment. |
| Arg2 | Required | Double | Present value of the investment. |
| Arg3 | Required | Double | Future value of the investment. |
Double
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.