TRY NEW VERSION

BITAND

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

Returns a bitwise 'And' of two numbers.

Parameters:

Name Type Description
arg1 number

Is the decimal representation of the binary number you want to evaluate.

arg2 number

Is the decimal representation of the binary number you want to evaluate.

Returns:

Type
number | string | boolean

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.BITAND(13, 25));
builder.SaveFile("xlsx", "BITAND.xlsx");
builder.CloseFile();

Resulting document