Excel like a finance pro.
← The libraryPractice · 2 questions →
Logical function
FALSE
Returns the logical value FALSE.
OccasionalDifficulty 850 · CapableUsage rank #172 of 520
When to use it
The logical value FALSE.
The shape of it
- Syntax
=FALSE()
Worked examples
The value
=FALSE() → FALSE
The value itself.
As a number
=--FALSE() → 0
FALSE is 0 in arithmetic.
From IF
=IF(A1>5,"x",FALSE()) → FALSE
Returning a logical from IF.
Worth knowing
- VLOOKUP's fourth argument accepts FALSE or 0 interchangeably.
- Typing FALSE in a cell gives a logical value.
- Rarely needed as a function.
Where it goes wrong
- "FALSE" in quotes is text.
- Empty cells are not FALSE in comparisons; they equal 0 and "".
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.