islogical
What Does It Do?
This function tests a cell to determine whether the cell contents are logical. The logical values can only be TRUE or FALSE. If the cell does contain a logical value, the result TRUE is shown.
If the cell does not contain a logical value, the result FALSE is shown.
Syntax
=ISLOGICAL(CellToTest)
Formatting
No special formatting is needed.
| Cell To Test | Result | |
| FALSE | TRUE | =ISLOGICAL(D4) |
| TRUE | TRUE | =ISLOGICAL(D5) |
| FALSE | =ISLOGICAL(D6) | |
| 20 | FALSE | =ISLOGICAL(D7) |
| 1-Jan-98 | FALSE | =ISLOGICAL(D8) |
| Hello | FALSE | =ISLOGICAL(D9) |
| #DIV/0! | FALSE | =ISLOGICAL(D10) |