Logical
FALSE
Definition
FALSE returns the logical value FALSE.
Syntax
=FALSE()
Arguments
| Argument | Meaning |
|---|---|
(none) |
FALSE takes no arguments, but the empty parentheses are still required. |
Worked example
A ticket booth flags a sale as cleared only when the amount is above 100. Amounts are in A2:A4.
| A: Amount |
|---|
| 40 |
| 150 |
| 80 |
Formula: =IF(A2>100,TRUE(),FALSE())
Result: FALSE. 40 is not above 100, so IF returns FALSE. Filled down, the formula gives FALSE, TRUE, and FALSE.
Practice
Cell B2 holds 1. In C2, write FALSE().
- In C2, write a FALSE formula.
Step 1 of 1
Enter =FALSE() in C2.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
C2 uses FALSE.
Related functions
FALSE is the value IF returns when a test fails, and NOT returns FALSE when the test it receives is true.
Common mistake
Wrapping the result in quotes, as in "FALSE": that is text, so IF and NOT do not treat it as the logical value FALSE.