TRY NEW VERSION

AMORDEGRC

AMORDEGRC(arg1., arg2., arg3., arg4., arg5., arg6., arg7.) → { number | string | boolean }

Returns the prorated linear depreciation of an asset for each accounting period..

Parameters:

Name Type Description
arg1. any
arg2. any
arg3. any
arg4. any
arg5. any
arg6. any
arg7. any

Returns:

Type
number | string | boolean

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.AMORDEGRC(3500, "1/1/2018", "3/1/2018", 500, 1, 0.25, 1));
builder.SaveFile("xlsx", "AMORDEGRC.xlsx");
builder.CloseFile();

Resulting document