PDURATION
function PDURATION(
arg1: number = null,
arg2: number = null,
arg3: number = null,
): number | string | booleanDescription
Returns the number of periods required by an investment to reach a specified value.
Parameters
- arg1
numberdefault: null Is the interest rate per period..
- arg2
numberdefault: null Is the present value of the investment.
- arg3
numberdefault: null Is the desired future value of the investment.
Returns
number | string | booleanTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.PDURATION("2.50%", 2000, 2200));