TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

PDURATION

PDURATION(arg1, arg2, arg3) → { number | string | boolean }

Returns the number of periods required by an investment to reach a specified value.

Parameters:

Name Type Description
arg1 number

Is the interest rate per period..

arg2 number

Is the present value of the investment.

arg3 number

Is the desired future value of the investment.

Returns:

Type
number | string | boolean

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.PDURATION("2.50%", 2000, 2200));
builder.SaveFile("xlsx", "PDURATION.xlsx");
builder.CloseFile();

Resulting document