ISLOGICAL Function
Checks whether a value is TRUE or FALSE.
Category
Information
Available in
All versions, Microsoft 365
Returns
TRUE or FALSE
Want to practice ISLOGICAL in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
ISLOGICAL returns TRUE when a value is one of the logical values TRUE or FALSE — from a checkbox, a comparison like B2>100, or a typed TRUE.
The word "TRUE" stored as text is not a logical value, so it returns FALSE.
Syntax
=ISLOGICAL(value) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| value | Yes | The value, cell or formula to check. |
Examples
Example 1 — Which flags are real logical values?
B3 holds the text "TRUE" from an import, and B4 holds 1.
C2fx=ISLOGICAL(B2)
| A | B | C | |
|---|---|---|---|
| 1 | Account | Active | Logical? |
| 2 | Brightline | TRUE | TRUE |
| 3 | Cobalt Ltd | TRUE | FALSE |
| 4 | Harbor & Co | 1 | FALSE |
| 5 | Vela Group | FALSE | TRUE |
=ISLOGICAL(B2) Explain
Common mistakes
- 1 and 0 return FALSE. Excel can use 1/0 in place of TRUE/FALSE in maths, but they are numbers, not logical values.
Notes
- Checkbox cells (Insert › Checkbox in Microsoft 365) hold TRUE/FALSE, so ISLOGICAL returns TRUE for them.
- Related functions: ISBLANK, ISNUMBER, ISTEXT, ISNONTEXT, ISLOGICAL, ISERROR, ISERR, ISNA, ISFORMULA, ISREF.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.