The Excel ISLOGICAL Function

Related Functions:

Function Description

The Excel Islogical function tests if a supplied value (or expression) returns a logical value (i.e. 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 following spreadsheet shows examples of the Excel Islogical function:

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

For further details and examples of the Excel 'Is' functions, see the Microsoft Office website.

Return to the Excel Information Functions Page
Return to the List of All Built-In Excel Functions