MS Excel: IsLogical Function
In Excel, the IsLogical function can be used to check for a logical value (ie: TRUE or FALSE).
The syntax for the IsLogical function is:
IsLogical( value )
value is the value that you want to test. If value is a TRUE or FALSE value , this function will return TRUE. Otherwise, it will return FALSE.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=IsLogical(A1) would return TRUE =IsLogical(A2) would return TRUE =IsLogical(A3) would return FALSE =IsLogical(A4) would return FALSE =IsLogical(TRUE) would return TRUE =IsLogical("TRUE") would return FALSE