Logical

FALSE Function in Excel

Returns the logical value FALSE.

Syntax

  • =FALSE()

Examples

  • =FALSE() - Return FALSE - Result: FALSE

Using FALSE in business rules

  • Build logical tests that return clear outcomes (Yes/No, Pass/Fail, tier labels).
  • Combine with [AND](/functions/and/) and [OR](/functions/or/) for multi-condition rules.
  • For many branches prefer [IFS](/functions/ifs/) over deeply nested IF.
  • Compare patterns in [IF vs IFS](/compare/if-vs-ifs/).

Common errors

  • Equivalent to typing FALSE directly

Use cases

  • Explicit logical values
  • Compatibility
  • Clarity in formulas

Frequently asked questions

  • Why use FALSE() instead of just typing FALSE? FALSE() and FALSE are equivalent. The function exists for compatibility with other spreadsheet applications. Most users type FALSE directly. Use whichever is clearer in your context.
  • What is the numeric value of FALSE? FALSE equals 0 in calculations. =FALSE()+1 returns 1. =FALSE()*5 returns 0. This is why SUMPRODUCT with conditions works: FALSE conditions contribute 0 to the sum.
  • How do I check if a cell contains FALSE? Use =A1=FALSE for exact match. Be careful: empty cells, 0, and text 'FALSE' are different from logical FALSE. =ISLOGICAL(A1) returns TRUE only for actual logical FALSE, not text or numbers.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.

When to use FALSE

  • Explicit logical values — common Logical scenario for FALSE.
  • Compatibility — common Logical scenario for FALSE.
  • Clarity in formulas — common Logical scenario for FALSE.

FALSE in the Logical category

  • Browse all Logical functions at /categories/logical/ for related formulas.
  • FALSE syntax: =FALSE()
  • Confirm FALSE arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.

Formula checklist before you copy down

  • Confirm FALSE arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.
  • If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
  • Spot-check three known input rows manually against expected output.

Related Excel functions

  • TRUE (/functions/true/): Returns the logical value TRUE.
  • IF (/functions/if/): Returns one value if a condition is TRUE and another value if it's FALSE.
  • AND (/functions/and/): Returns TRUE if all arguments are TRUE; returns FALSE if any argument is FALSE.
  • OR (/functions/or/): Returns TRUE if any argument is TRUE; returns FALSE only if all arguments are FALSE.

Errors to watch for

  • Equivalent to typing FALSE directly — review causes on linked error pages in the directory.

Copy-paste audit workflow

  • Enter FALSE on three test rows with known expected output documented on a QA tab.
  • Fill down only after absolute references are locked on lookup tables and rate tables.
  • Compare against manual calculation or a calculator for financial and statistical functions.
  • Search this directory for comparison guides when choosing between similar functions in the same category.

FALSE worked examples to copy

  • =FALSE() — Return FALSE. Expected result: FALSE.

FALSE reference summary for crawlers and offline review

  • FALSE belongs to the Logical category in Excel. Returns the logical value FALSE.
  • Full syntax: =FALSE(). Open /functions/false/ for parameters, FAQs, and related pages.
  • Common mistakes: Equivalent to typing FALSE directly
  • Pair this function with comparison guides when another Excel formula might fit the same task better.
  • Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.