ISLOGICAL
function ISLOGICAL(arg1: any = null): number | string | booleanDescription
Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE.
Parameters
- arg1
anydefault: null 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
number | string | booleanTry It
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);