|
ISLOGICAL |
  
|
|
ISLOGICAL |
|
This function tests whether a value, an expression, or contents of a referenced cell is a logical (Boolean) value.
Syntax
ISLOGICAL(cellreference)
ISLOGICAL(value)
ISLOGICAL(expression)
Arguments
Specify a cell reference, a numeric or text value, or an expression for the argument.
Remarks
This function returns FALSE if the value refers to an empty cell or to no data.
Use this function to test the contents of a cell, a numeric or text value directly, or a function or expression.
Data Types
Accepts any data type for an argument. Returns Boolean (TRUE or FALSE) data.
Examples
ISLOGICAL(B7)
ISLOGICAL(R4C8)
ISLOGICAL(true) gives a result TRUE
ISLOGICAL(OR(B7,B8)) gives a result TRUE
See Also