The Excel ISLOGICAL Function

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 either a simple value, a value returned from a formula, or a reference to a cell containing a value.


Islogical Function Examples

The spreadsheets below show several examples of the Excel Islogical function. The spreadsheet on the left shows the formulas used, and the spreadsheet on the right shows the results:

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

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 it is simply testing if the expression 'B1=B2' evaluates to a logical value.

Return to the Excel Information Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net