In this article
FALSE() returns the logical value FALSE, most often seen as the exact-match argument in VLOOKUP.
Advertisement
Syntax
=FALSE()Examples
Example 1
=FALSE()Result: FALSE. See the worked example table below for more cases.
FALSE in practice
Where you will use it
- Exact-match flags in VLOOKUP
- Testing logic
- Compatibility
Worked example
| Check | Formula | Result |
|---|---|---|
| Value | =FALSE() | FALSE |
| As a number | =FALSE()*1 | 0 |
| In VLOOKUP | =VLOOKUP("B",{"A",1;"B",2},2,FALSE()) | 2 |
Results calculated in Excel.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| "FALSE" in quotes | Text, not logical |
| Using 0 instead | 0 works too, but FALSE reads better |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
Advertisement
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong