FALSE function
FALSE returns the logical value FALSE. You can also type FALSE directly into a cell, so the function exists mainly for compatibility with other spreadsheet programs.
Example
A
B
C
D
1
FALSE
2
3
Syntax
FALSE()
FALSE takes no arguments.
Returns: The logical value FALSE.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=FALSE() | FALSE | Function form |
=FALSE | FALSE | Constant form |
=FALSE()+1 | 1 | Arithmetic |
=FALSE()=0 | FALSE | Compared with 0 |
Watch out for
- Typing FALSE in a cell gives the same logical value.
Where it works
- Excel
- FALSE is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Logical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .