Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
ISLOGICAL
ISLOGICAL checks whether a cell or expression evaluates to a Boolean TRUE or FALSE, returning TRUE in that case and FALSE for numbers, text, errors, or blank values. Use it to validate that cells expected to hold checkboxes or Boolean flags actually contain logical values rather than text representations like the word "TRUE".
Excel
=ISLOGICAL(A2)Google Sheets
=ISLOGICAL(A2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Flag | IsLogical? |
| TRUE | TRUE |
| Yes | FALSE |
| FALSE | TRUE |
=ISLOGICAL(A2)→TRUE
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Reference the cell or provide the value to test (e.g., =ISLOGICAL(A2)).
- 2ISLOGICAL returns TRUE only for the Boolean values TRUE and FALSE, not for the text strings "TRUE" or "FALSE".
- 3Use in data validation or conditional formulas to confirm checkbox or flag columns hold real Boolean values.
Need a version for your data?
Try: “Verify that my flag column contains real TRUE/FALSE values not text”