The ISLOGICAL function tests if a supplied value (or expression) evaluates to a logical (ie. evaluates to True or False). If so, the function returns TRUE; Otherwise, it returns FALSE.

Syntax

=ISLOGICAL(value)

Arguments

Argument Description
value The value argument is either a simple value, a value returned from a formula, or a reference to a cell containing a value

Examples

  A B C D
1   Formula Result Notes
2 3 =ISLOGICAL(A2=A3) TRUE  
3 3 =ISLOGICAL(A2=A4) TRUE The function is testing whether the expression evaluates to a logical value, not if cells are or are not equal
4 5 =ISLOGICAL(TRUE) TRUE  
5   =ISLOGICAL(FALSE) TRUE  
6   =ISLOGICAL(20/5) FALSE  
7 text =ISLOGICAL(A7) FALSE  
8 FALSE =ISLOGICAL(A8) TRUE