AND

AND() → { number | string | boolean }

Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE.

Parameters:

Returns:

Type

number | string | boolean

Example

builder.CreateFile("xlsx");
const oWorksheet = Api.GetActiveSheet();

var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.AND(12 < 100, 34 < 100, 50 < 100); //AND logical function

oWorksheet.GetRange("C1").SetValue(ans);

builder.SaveFile("xlsx", "AND.xlsx");
builder.CloseFile();

Resulting document