RRI
function RRI(
arg1: number = null,
arg2: number = null,
arg3: number = null,
): number | string | booleanDescription
Returns an equivalent interest rate for the growth of an investment.
Parameters
- arg1
numberdefault: null Is the number of periods for the investment.
- arg2
numberdefault: null Is the present value of the investment.
- arg3
numberdefault: null Is the future value of the investment.
Returns
number | string | booleanTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.RRI(12, 10000, 20000));