ISLOGICAL function
ISLOGICAL returns TRUE if a value is a logical, meaning TRUE or FALSE, and FALSE otherwise. The text "TRUE" in quotes is not a logical.
Example
Read it as a sentence: check whether F4 holds TRUE or FALSE, which gives TRUE.
Excel shows TRUE
F
1
2
'123
3
2024-02-29
4
TRUE
Data
Syntax
ISLOGICAL(value)
-
value(required) - The value to check.
Returns: TRUE for TRUE or FALSE.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ISLOGICAL(TRUE) | TRUE | Bool |
=ISLOGICAL(1) | FALSE | Number |
=ISLOGICAL("TRUE") | FALSE | Text |
=ISLOGICAL(1>0) | TRUE | Comparison |
=ISLOGICAL(Data!F4) | TRUE | Bool cell |
=ISLOGICAL(Data!F1) | FALSE | Blank |
The Data sheet these formulas read
A cell that starts with = holds that formula.
F
1
2
'123
3
2024-02-29
4
TRUE
Data
Watch out for
- The text "TRUE" is not a logical.
Where it works
- Excel
- ISLOGICAL is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Information functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .