ISLOGICAL Function (Functions in Excel)
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. |
0 comments:
Post a Comment