Logical · the boolean constant · Nov 2026

The FALSE function,
measured & explained.

Syntax, a live playground, a measured coercion gallery, FALSE vs 0, and a sourced error library: the logical constant FALSE.

fx
LookupLab Research
By LookupLab Research·Updated Nov 16, 2026·Engine: HyperFormula 3.5·What FALSE returns
D1
fx
=FALSE()
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
▶ Try the playground Try FALSE live ↓See the 6 errors
// 01 — Anatomy

How FALSE works

Returns the logical value FALSE. It takes no arguments; its interest is how FALSE coerces in math and differs from the number 0.

=FALSE()
no argumentsFALSE() takes none; it returns the logical value FALSE.
vs literalThe bare literal FALSE also works in Excel.
coercionIn math FALSE behaves as 0.
// 02 — The boolean constant

What FALSE actually does

FALSE() takes no arguments and returns the logical value FALSE. Like TRUE, its real interest is coercion — FALSE behaves as 0 in math but is not the text "FALSE". Every row was measured live in HyperFormula. Click any row to load it.

Measured behavior gallery

ExpressionResultWhy
=FALSE()FALSEThe function returns the logical value FALSE
=FALSE()+11FALSE coerces to 0, so 0+1=1
=FALSE()*990FALSE behaves as 0 in math
=IF(FALSE,"yes","no")noIF takes the FALSE branch
=FALSE="FALSE"FALSELogical FALSE is not the text "FALSE"
=OR(FALSE,0)FALSE0 coerces to FALSE inside OR
=NOT(FALSE)TRUENOT flips FALSE to TRUE
=SUM(FALSE,FALSE)0Logical arguments count as 0

The SUM trap: booleans in a range are ignored

SUM ignores logical values in a reference but counts them as direct arguments. Measured below.

ExpressionResultWhy
=SUM(A2:A5)0The flag column holds booleans; SUM ignores them in a range
=SUM(FALSE,FALSE)0As direct arguments FALSE counts as 0
=COUNTIF(A2:A5,FALSE)2COUNTIF matches logical FALSE
=SUMPRODUCT(--A2:A5)2Coercing counts the TRUEs, not the FALSEs
⚠ FALSE is not the number 0. FALSE coerces to 0 in arithmetic, but it is a logical value, not a number — comparisons and aggregates treat it specially.
FALSE() vs the literal FALSE. Both work in Excel; some engines need FALSE() or a registered literal. This playground registers both.
// 03 — Try it live

Interactive FALSE playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset to see FALSE coerce in math, branch in IF, and invert with NOT.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

6 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.

🔍
// 05 — Cross-platform

Where FALSE works

FALSE is available across modern Excel, Google Sheets and LibreOffice. It has been in Excel since 2003.

PlatformSupportNotesGotcha
✓ Supported full FALSE◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master logical logic

FALSE is one piece. The full course walks the toolkit end to end with live, measured examples.

  • TRUE / FALSE — the boolean constants
  • Coercion: FALSE=0 in math, but not the number 0
  • The SUM-ignores-booleans trap
  • Inverting with NOT and double negatives
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked