TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

MOD

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

Returns the remainder after a number is divided by a divisor.

Parameters:

Name Type Description
arg1 number

Is the number for which you want to find the remainder after the division is performed.

arg2 number

Is the number by which you want to divide Number.

Returns:

Type
number | string | boolean

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.MOD(65, 7));
builder.SaveFile("xlsx", "MOD.xlsx");
builder.CloseFile();

Resulting document