Excel FALSE Function

Excel FALSE Function
Example

Related Functions

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 

 

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
Logo