Exceljet

Quick, clean, and to the point

Excel FALSE Function

Excel FALSE function
Summary 

The Excel FALSE function returns the value FALSE. FALSE is classified as a compatibility function, and not needed in most cases. It is equivalent to using the Boolean value FALSE directly in a formula.

Purpose 
Generate the logical value FALSE
Return value 
The logical value FALSE
Syntax 
=FALSE ()
Arguments 
Version 
Excel 2003
Usage notes 

The FALSE function takes no arguments and generates the boolean value FALSE. 

For example, to return FALSE if if the value in A1 < 0, use the formula:

=IF(A1<0, FALSE())

Note that you can also just use enter the word FALSE directly into a cell or formula and Excel will interpret this as the logical value FALSE. For example, these formulas are functionally identical:

=IF(A1<0, FALSE())
=IF(A1<0, FALSE)

Both formulas return FALSE if the value in A1 < 0.

Microsoft labels the FALSE function a "compatibility function", in Excel for compatibility with other spreadsheet applications.

Related functions 
Excel TRUE function
Excel TRUE Function

The Excel TRUE function returns the value TRUE. TRUE is classified as a compatibility function, and not needed in most cases. It is equivalent to using the Boolean value TRUE directly in a formula.

Excel IF function
Excel IF Function

The 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. The IF...

500 Formulas | 101 Functions

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.