FALSE Function in Excel and Google Sheets
Purpose
Return the boolean value FALSE
Return value
The logical value FALSE
FALSE() returns the boolean constant FALSE. Like its counterpart TRUE(), it exists for compatibility and for making formula intent self-documenting, and writing FALSE without parentheses is equally valid. The place where FALSE matters most in practice is as the fourth argument of VLOOKUP, where it specifies exact match. This is critical enough to be worth an entire paragraph of emphasis: if you omit the fourth argument in VLOOKUP, the function defaults to approximate match and silently returns wrong results whenever the lookup column is not sorted. I have spent hours debugging spreadsheets where this single omission caused rows to pull data from the wrong records with no error and no visible indication that anything was wrong. Always write FALSE. Always. Beyond VLOOKUP, FALSE() appears in conditional formulas as the default value, in COUNTIF to count boolean FALSE cells, and anywhere the explicit boolean FALSE is needed as a function argument rather than a comparison result.
Syntax
✓ Excel 2003+
✓ Google Sheets
= Same syntax
=FALSE()
Arguments
| Argument | Required | Description |
|---|---|---|
| none | Optional |
How it works
FALSE() returns the boolean constant FALSE and can be placed anywhere a boolean is expected. Its most important use is in VLOOKUP as the range_lookup argument to enforce exact matching: =VLOOKUP(A2,table,col,FALSE()). Omitting this argument defaults to TRUE (approximate match) which returns silently wrong results on unsorted data. In IF formulas, FALSE() can be returned as the value_if_false when the formula needs to explicitly produce a boolean rather than a number or text. In COUNTIF, passing FALSE without quotes counts cells containing the boolean FALSE, while passing "FALSE" in quotes counts cells containing the text string FALSE — a meaningful difference when auditing imported data. When testing whether a cell contains the boolean FALSE, use =B2=FALSE() which distinguishes the boolean from the text string, identical to the approach used with TRUE().
Examples
1
Use FALSE() as the range_lookup argument in VLOOKUP to enforce exact matching when looking up product names from a reference table by code.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Lookup Code | Product Name | Code | Product |
| 2 | PRD-003 | =VLOOKUP(A2,$D$2:$E$7,2,FALSE()) | PRD-001 | Wireless Mouse |
| 3 | PRD-006 | Webcam HD | PRD-002 | USB Keyboard |
| 4 | PRD-001 | Wireless Mouse | PRD-003 | Monitor Stand |
| 5 | PRD-004 | Laptop Bag | ||
| 6 | PRD-005 | HDMI Cable | ||
| 7 | PRD-006 | Webcam HD |
Row 2: Monitor Stand
— PRD-003 is found in the code column and Monitor Stand is returned from the product name column. FALSE() enforces exact matching — only an identical code qualifies.
FALSE() here is identical to writing FALSE or 0. The function form makes the exact match intent explicit. If this argument were omitted, VLOOKUP would default to approximate match and could return wrong results for unsorted data.
2
Use FALSE() as a returned value in IF — return the boolean FALSE when a condition fails to confirm a stock reorder is not needed.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Product | Stock | Reorder Point | Needs Reorder |
| 2 | Mouse | 15 | 20 | TRUE |
| 3 | Keyboard | 45 | 10 | =IF(B3<C3,TRUE(),FALSE()) |
| 4 | Monitor | 8 | 25 | TRUE |
| 5 | Cable | 32 | 30 | FALSE |
| 6 | Webcam | 5 | 15 | TRUE |
Row 2: FALSE
— Keyboard has 45 units in stock and a reorder point of 10 — 45 is not less than 10 so the condition B3<C3 is FALSE and the formula returns FALSE().
Mouse, Monitor, and Webcam have stock below their reorder points so TRUE() is returned for each. Returning explicit booleans makes the column suitable for downstream COUNTIF, SUMIF, and filter conditions.
3
Use COUNTIF with FALSE to count how many cells in a boolean column contain the logical value FALSE.
| A | B | C | |
|---|---|---|---|
| 1 | Row | Value | Result |
| 2 | 1 | TRUE | |
| 3 | 2 | FALSE | |
| 4 | 3 | TRUE | |
| 5 | 4 | FALSE | |
| 6 | 5 | FALSE | |
| 7 | 6 | TRUE | |
| 8 | 7 | FALSE | |
| 9 | 8 | TRUE | |
| 10 | 9 | FALSE | |
| 11 | 10 | FALSE | |
| 12 | =COUNTIF(B2:B11,FALSE) |
Row 2: 6
— Six cells contain the boolean FALSE: rows 2, 4, 5, 7, 9, and 10. The four boolean TRUE cells are not counted.
COUNTIF(range,FALSE) counts boolean FALSE cells. COUNTIF(range,"FALSE") would instead count cells containing the text string FALSE — a different result if the column contains text rather than booleans.
Common use cases
1. Use as the range_lookup argument in every VLOOKUP for exact matching on codes, IDs, and names
=VLOOKUP(A2,$D:$F,3,FALSE())
2. Return the boolean FALSE explicitly from IF when a downstream formula depends on a boolean column rather than text
=IF(B2<C2,TRUE(),FALSE())
3. Count boolean FALSE values in a response column to measure how many conditions failed
=COUNTIF(B2:B100,FALSE)
4. Check whether a cell contains the actual boolean FALSE rather than the text string for data-quality validation
=B2=FALSE()
5. Use as the syntax_same argument indicator in data schema validation where 0 or FALSE signals a mismatch
=AND(B2=FALSE(),C2=FALSE())
Common errors
VLOOKUP returns wrong results with no error
The fourth argument was omitted or set to TRUE on data that is not sorted ascending — VLOOKUP silently returns results from the wrong row.
Fix: Always write FALSE as the fourth VLOOKUP argument explicitly. Never omit it. Use TRUE only intentionally for approximate match on sorted bracket tables.
COUNTIF with FALSE counts too many or too few cells
The cells contain the text string "FALSE" rather than the boolean FALSE, or vice versa. COUNTIF treats them as different values.
Fix: Use ISLOGICAL(B2) to check whether cells contain actual booleans. Use COUNTIF(range,FALSE) for boolean FALSE cells and COUNTIF(range,"FALSE") for the text string.
IF returns FALSE text instead of the boolean value
Writing =IF(condition,TRUE,FALSE) without parentheses in some older spreadsheet contexts can return the text words TRUE and FALSE rather than booleans if the cells are formatted as text.
Fix: Use TRUE() and FALSE() with parentheses to be explicit. Format the output column as General rather than Text to ensure the results display as booleans.
Tips and variations
Always write FALSE explicitly as the fourth VLOOKUP argument
Omitting the fourth argument defaults to TRUE which causes silent wrong results on unsorted data. This is one of the most common and hardest-to-diagnose bugs in shared spreadsheets. Writing FALSE explicitly every time makes the intent clear and prevents the bug entirely.
=VLOOKUP(A2,$D:$F,3,FALSE)
Use ISLOGICAL to distinguish boolean FALSE from the text string
Data imported from external sources often represents FALSE as the text string rather than the boolean. ISLOGICAL(B2) returns TRUE only for actual booleans. Combine with COUNTIF(range,FALSE) for an audit of boolean columns.
=ISLOGICAL(B2)
Return boolean columns from IF for downstream formula compatibility
IF formulas that return TRUE() and FALSE() produce boolean columns that COUNTIF, SUMIF, and filter conditions can use directly. IF formulas that return text like "Yes" and "No" require text comparisons downstream. Boolean columns are more composable.
=IF(B2<C2,TRUE(),FALSE())
Excel vs Google Sheets
Excel vs Google Sheets
FALSE() works identically in Excel 2003 and newer and every version of Google Sheets. The syntax, return value, and behaviour as a function argument are the same in both applications. The distinction between boolean FALSE and the text string FALSE is also consistent across both.
Frequently asked questions
FALSE() returns the boolean value FALSE. It takes no arguments. Like TRUE(), it exists for compatibility and for making formula intent explicit. Writing FALSE without parentheses returns the identical value. Its most common use is as the range_lookup argument in VLOOKUP to specify exact matching.
Yes. FALSE(), FALSE, and 0 all evaluate to the boolean FALSE in logical contexts. In VLOOKUP's fourth argument, all three produce exact match behaviour. The function form FALSE() is the most self-documenting because it explicitly names what it represents, but all three are interchangeable.
Always specify FALSE explicitly in VLOOKUP as the fourth argument. If you omit the fourth argument, VLOOKUP defaults to TRUE (approximate match), which silently returns wrong results on unsorted data — one of the most common and hardest-to-spot bugs in shared spreadsheets. Always write FALSE explicitly.
The boolean FALSE is a logical value that formulas evaluate. The text string FALSE in quotes is just text that looks like FALSE. COUNTIF(range,FALSE) counts cells containing the boolean FALSE. COUNTIF(range,"FALSE") counts cells containing the text string FALSE. Logical functions like IF and AND use the boolean value, not the text.
Yes. FALSE() works identically in Excel and Google Sheets. The syntax, return value, and behaviour as a function argument are the same in both applications.