Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE.
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. |
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();