The Excel Spreadsheet Excelclopedia
Printable ViewExcel ISLOGICAL Function
Syntax
=ISLOGICAL(value)
Checks if the value, reference or expression equates to boolean value TRUE or FALSE
Returns TRUE or FALSE
Note: This can get confusing. In the example below the function =ISLOGICAL(100=50) returns TRUE - because the answer (FALSE, 100 does not equal 50) is a boolean Value (TRUE or FALSE)
Examples
| A | B | C | D | E | F | G |
| 2 | Cell references | Returned Values | ||||
| 3 | 100 | 200 | =+B3=C3 | =ISLOGICAL(D3) | TRUE | |
| 4 | 100 | 100 | =+B4=C4 | =ISLOGICAL(D4) | TRUE | |
| 5 | cell C5 is blank | =ISLOGICAL(D5) | FALSE | |||
| 6 | =1701/0 | =ISLOGICAL(D6) | FALSE | |||
| 7 | ||||||
| 8 | Formulas | |||||
| 9 | 100 | 100 | =ISLOGICAL(D9=C9) | TRUE | ||
| 10 | 100 | 50 | =ISLOGICAL(D10=C10) | TRUE | ||
| 11 | 12 | 0 | =ISLOGICAL(B11/D11) | FALSE | ||
| 12 | 12 | 12 | =ISLOGICAL(B12/D12) | FALSE | ||
| 12 | ||||||
| 14 | Values | |||||
| 15 | =ISLOGICAL("abc") | FALSE | ||||
| 16 | =ISLOGICAL("TRUE") | FALSE | ||||
| 17 | =ISLOGICAL(TRUE) | TRUE |
Categories: IS Functions