The Excel FALSE function returns the logical value FALSE. Like its twin TRUE, it takes no arguments and exists mainly for compatibility with other spreadsheet programs — the bare literal FALSE does exactly the same job. What’s worth ten minutes of your time is the value itself: FALSE becomes 0 in arithmetic, which is why failed tests vanish from SUMPRODUCT totals, and FALSE is the argument that makes VLOOKUP behave.
=VLOOKUP(E2, A:C, 3, FALSE).
Syntax
| Argument | Description | |
|---|---|---|
| none | FALSE() takes no arguments. The empty parentheses are required if you use the function form. |
Available in: every version of Excel. Microsoft keeps FALSE() for compatibility with other spreadsheet applications — in practice, type the literal FALSE (or just 0 where a function accepts it) and move on.
Where FALSE shows up in real formulas
FALSE appears as an argument far more often than as a result you build deliberately. The most famous example in all of Excel:
Leaving that FALSE off switches VLOOKUP to approximate matching — the source of countless silent wrong answers. Other regulars:
Anywhere a function asks a yes/no question — match type, by column, ignore hidden — the answer is a TRUE/FALSE value, and most such arguments also accept 1/0 shorthand.
Try it: FALSE in boolean arithmetic
Pick a status to test for. Rows that fail return FALSE, coerce to 0, and drop out of the SUMPRODUCT total — the amounts are A2:B6 below.
FALSE = 0: why failed tests vanish from totals
Arithmetic coerces logical values to numbers: TRUE → 1, FALSE → 0. The zero half of that rule is what makes conditional sums work — every row that fails the test contributes exactly nothing.
| A | B | C | |
|---|---|---|---|
| 1 | Formula | Result | Why |
| 2 | =FALSE() | FALSE | same as typing FALSE |
| 3 | =FALSE()+1 | 1 | math coerces FALSE to 0 |
| 4 | =--(3>5) | 0 | a failed test becomes 0 |
| 5 | =FALSE()*99 | 0 | 0 × anything is 0 |
The -- double minus is the standard way to convert a test’s TRUE/FALSE into 1/0 (minus, then minus again, leaves 1 or 0). The mechanics are covered in full on the TRUE page; FALSE is simply the side of the coin that lands on zero.
Blank vs FALSE: an empty cell is not FALSE, but most logical arguments treat an omitted argument as FALSE — one reason =VLOOKUP(x, table, 2) with the last argument missing behaves as TRUE (approximate) instead is that VLOOKUP’s default is the exception, not the rule. When in doubt, state the value explicitly.
Pitfalls to avoid
Pitfall: the text “FALSE” is not the value FALSE. ="FALSE" is a string. It won’t satisfy =A2=FALSE and it errors in arithmetic. Convert imported text booleans with =A2="TRUE", which yields a genuine logical.
Pitfall: FALSE doesn’t equal 0 in comparisons. Coercion is an arithmetic behavior. =FALSE=0 returns FALSE because a logical and a number are different types; =FALSE+0=0 returns TRUE.
Pitfall: omitting a TRUE/FALSE argument and guessing the default. VLOOKUP defaults to TRUE (approximate), MATCH defaults to 1 — rarely what you want. Write the FALSE/0 explicitly so the formula says what it does.
#NAME? — almost always a typo. FALSE exists in every version of Excel, so a name error here means a misspelling such as FALS or a stray character.
Practice workbook
Frequently asked questions
What's the difference between FALSE and FALSE() in Excel?
FALSE is standard practice.Why do people put FALSE at the end of VLOOKUP?
=VLOOKUP(x, table, col, FALSE) — or 0 — is the safe habit.Does FALSE equal 0?
=FALSE+1 is 1 and =FALSE*99 is 0. In comparisons, no: =FALSE=0 returns FALSE because logicals and numbers are distinct types in Excel.Can I use 0 instead of FALSE in function arguments?
How do I count FALSE values in a range?
=COUNTIF(A2:A100, FALSE) counts cells holding the logical value FALSE. For failed tests computed on the fly, count the inverse: =SUMPRODUCT(--(B2:B100<=0)) or subtract passes from the total.Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class