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

ArgumentRequired?What it does
valueYesThe 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)
ABC
1AccountActiveLogical?
2BrightlineTRUETRUE
3Cobalt LtdTRUEFALSE
4Harbor & Co1FALSE
5Vela GroupFALSETRUE
=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

Kyle Stott

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.