Quick, clean, and to the point

Excel FALSE Function

Excel FALSE function

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.

Generate the logical value FALSE
Return value 
The logical value FALSE
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.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas