Excel like a finance pro.
← The libraryPractice · 2 questions →
Information function
ISLOGICAL
Returns TRUE if a value is TRUE or FALSE.
Rarely usedDifficulty 1050 · CapableUsage rank #244 of 520
When to use it
TRUE when a value is the logical TRUE or FALSE, not text that reads the same.
The shape of it
- Syntax
=ISLOGICAL(value)
Worked examples
Logical
=ISLOGICAL(TRUE) → TRUE
A logical value.
Text that looks logical
=ISLOGICAL("TRUE") → FALSE
Text.
A comparison
=ISLOGICAL(A1>5) → TRUE
Comparisons produce logicals.
Worth knowing
- Imported TRUE/FALSE columns are often text; ISLOGICAL finds them.
- Convert text to logical with =A1="TRUE".
- Checkbox cells in newer Excel hold logicals.
Where it goes wrong
- Numbers 1 and 0 are not logicals.
- Rarely needed outside data cleanup.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.