ISLOGICAL

Posted on 18-01-2020 , by: admin , in , 0 Comments

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)

Leave a comment