ISLOGICAL Function
Checks whether a value is a logical value, (TRUE or FALSE), and returns TRUE or FALSE.
Syntax
ISLOGICAL(<value>)
Parameters
Term |
Definition |
|---|---|
value |
The value that you want to test. |
Property Value/Return Value
TRUE if the value is a logical value; FALSE if any value other than TRUE OR FALSE.
Example
The following three samples show the behavior of ISLOGICAL.
//RETURNS: Is Boolean type or Logical
=IF(ISLOGICAL(true), "Is Boolean type or Logical", "Is different type")
//RETURNS: Is Boolean type or Logical
=IF(ISLOGICAL(false), "Is Boolean type or Logical", "Is different type")
//RETURNS: Is different type
=IF(ISLOGICAL(25), "Is Boolean type or Logical", "Is different type")