The Excel ISLOGICAL Function

Related Functions:
ISERROR
ISNUMBER
ISREF
ISTEXT

Basic Description

The Excel 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.

The syntax of the function is:

ISLOGICAL( value )

Where the supplied value argument is the value or expression to be tested.


Islogical Function Examples

The spreadsheets below show several examples of the Excel Islogical function:

 Formulas:
 AB
1=ISLOGICAL( TRUE ) 
2=ISLOGICAL( FALSE ) 
3=ISLOGICAL( B1=B2 ) 
4=ISLOGICAL( 20/5 ) 
5=ISLOGICAL( B5 )text
6=ISLOGICAL( B6 )FALSE
 Results:
 AB
1TRUE 
2TRUE 
3TRUE 
4FALSE 
5FALSEtext
6TRUEFALSE

Note that the Islogical function in cell A3 would still return TRUE, even if cells B1 and B2 were not equal, as the Islogical function is simply testing if the expression 'B1=B2' evaluates to any logical value.


Further information and examples of the Excel 'Is' functions are provided on the Microsoft Office website.