Author: Oscar Cronquist Article last updated on May 04, 2022

The FALSE function returns the logical (boolean) value FALSE.

1. FALSE Function Syntax


Back to top

2. FALSE Function Arguments

The FALSE function has no arguments.

Back to top

3. FALSE Function Example

Excel interprets the boolean value FALSE exactly the same as =FALSE(), you most often don't need the FALSE function. It exists primarily for compatibility with other software.

Formula in cell C3:

=IF(1=2, TRUE(), FALSE())

Explaining formula

Step 1 - Logical expression

The equal sign lets you compare value to another value.


returns FALSE.

Step 2 - Evaluate IF Function

The IF function returns one value if the logical test is TRUE and another value if the logical test is FALSE.

IF(logical_test, [value_if_true], [value_if_false])

IF(1=2, TRUE(), FALSE())



and returns FALSE(). FALSE() returns FALSE.

Back to top