ISLOGICAL
Checks whether a value is a logical value (-true or -false), and returns -true or -false.
Syntax
expression.ISLOGICAL(arg1);
expression - A variable that represents a ApiWorksheetFunction class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| arg1 | Required | ApiRange | string | number | boolean | ApiName | The value to test.\ The value can be an empty cell, error, logical value, text, number, range, or range name. |
Returns
boolean
Example
- Code
- Result
const worksheet = Api.GetActiveSheet();
worksheet.GetRange("B3").SetValue("66");
let func = Api.GetWorksheetFunction();
let result = func.ISLOGICAL(worksheet.GetRange("B3"));
worksheet.GetRange("C3").SetValue(result);