Quick Navigation

FALSE Function

Excel 2007+

Summary

The FALSE function returns the logical value FALSE. It's a simple, no-argument function primarily used for compatibility with other spreadsheet applications and as a clear way to insert the FALSE logical value in formulas.

Syntax

FALSE()

Using the FALSE Function

FALSE() provides a programmatic way to return the logical FALSE value. While you can type FALSE directly into cells or formulas, using the function ensures compatibility with other applications and makes formulas more explicit.

Common FALSE Examples

Basic FALSE Usage

=IF(A1>100, TRUE(), FALSE())

Returns FALSE if A1 is 100 or less in a conditional check.

Combined with TRUE

=IFERROR(VLOOKUP(B1,C1:D10,2,FALSE), "Not found")

Uses FALSE as the exact match parameter in VLOOKUP.

Direct Cell Value

=FALSE()

Simply returns FALSE logical value in a cell.

Frequently Asked Questions

Yes, Excel recognizes the word FALSE directly, but the FALSE() function ensures compatibility with other spreadsheet programs.

FALSE represents the logical false value, while 0 is numeric. Use FALSE for clarity in logical operations.

Common Errors and Solutions

#NAME? error

Cause: FALSE misspelled or unavailable in older Excel versions

Solution: Ensure correct spelling: FALSE() and verify Excel version

Notes

FALSE() has been available since early Excel versions
Use FALSE in IF statements, AND/OR conditions, array formulas
The function exists mainly for compatibility - direct typing works in Excel

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in:

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+