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

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.