islogical
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) |
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.