TRY NEW VERSION

ISLOGICAL

ISLOGICAL(arg1) → { number | string | boolean }

Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE.

Parameters:

Name Type Description
arg1 any

Is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value.

Returns:

Type
number | string | boolean

Example

Copy code
builder.CreateFile("xlsx");

const oWorksheet = Api.GetActiveSheet();
oWorksheet.GetRange("B3").SetValue("66");

var oFunction = Api.GetWorksheetFunction();
var result = oFunction.ISLOGICAL(oWorksheet.GetRange("B3"));
oWorksheet.GetRange("C3").SetValue(result);

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

Resulting document