Excel like a finance pro.
← The libraryPractice · 2 questions →
Logical function
TRUE
Returns the logical value TRUE.
OccasionalDifficulty 850 · CapableUsage rank #173 of 520
When to use it
The logical value TRUE. You can type TRUE directly; the function form exists for compatibility.
The shape of it
- Syntax
=TRUE()
Worked examples
The value
=TRUE() → TRUE
The value itself.
Count TRUEs
=COUNTIF(A2:A10,TRUE()) → 4
How many checkbox cells are ticked.
As a number
=TRUE()*1 → 1
TRUE is 1 in arithmetic.
Worth knowing
- Typing TRUE in a cell creates a logical value, not text.
- Use it as the default condition in IFS.
- Count TRUEs with SUMPRODUCT(--range) or COUNTIF(range,TRUE).
Where it goes wrong
- "TRUE" in quotes is text, not logical.
- Rarely needed as a function.
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.