AMORDEGRC
function AMORDEGRC(
arg1.: any = null,
arg2.: any = null,
arg3.: any = null,
arg4.: any = null,
arg5.: any = null,
arg6.: any = null,
arg7.: any = null,
): number | string | booleanDescription
Returns the prorated linear depreciation of an asset for each accounting period..
Parameters
- arg1.
anydefault: null - arg2.
anydefault: null - arg3.
anydefault: null - arg4.
anydefault: null - arg5.
anydefault: null - arg6.
anydefault: null - arg7.
anydefault: null
Returns
number | string | booleanTry It
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));