Excel FALSE Function

Excel FALSE Function

Related Functions


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. Use FALSE to generate the logical value FALSE. For example, to return FALSE if if the value in A7 < 0, use the formula:

=IF(A7<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(A7<0, FALSE())

=IF(A7<0, FALSE)

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

Microsoft states that the FALSE function is provided mainly for compatibility with other spreadsheet applications.

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas