How to use the Excel FALSE function

Summary

The Excel FALSE function returns the Boolean value FALSE. The FALSE function is classified as a "compatibility function", needed only for compatibility with other spreadsheet applications. There is no need to use FALSE() if you are creating a spreadsheet in Excel.

Purpose

Generate the logical value FALSE

Return value

The logical value FALSE

Syntax

=FALSE ()

Arguments

Version

Excel 2003

Usage notes

The FALSE function returns the Boolean value FALSE. In other words, the three formulas below based on the IF function are functionally equivalent:

=IF(A1>65,"OK",FALSE())
=IF(A1>65,"OK",FALSE)
=IF(A1>65,"OK")

All three formulas return FALSE if the value in A1 is not greater than 65.

The FALSE function is classified as a "compatibility function", needed only for compatibility with other spreadsheet applications. There is no need to use the FALSE function if you are creating a spreadsheet in Excel.

Note that logical expressions will automatically generate TRUE and FALSE results. For example, the formula below will automatically return TRUE if the value in A1 is greater than 90 and FALSE if not:

=A1>90

To test a condition and return different results based on whether the results are TRUE or FALSE, see the examples on this page.

Related functions

Excel TRUE Function

The Excel TRUE function returns the Boolean value TRUE. The TRUE function is classified as a "compatibility function", needed only for compatibility with other spreadsheet applications. There is no need to use TRUE() if you are creating a...

Excel IF Function

The Excel IF function runs a logical test and returns one value for a TRUE result, and another for a FALSE result. For example, to "pass" scores above 70: =IF(A1>70,"Pass","Fail"). More than one condition can be tested by nesting IF functions....

Exceljet

Quick, clean, and to the point

Excel FALSE Function

Download 100+ Important Excel Functions

Excel video training