FALSE function

FALSE returns the logical value FALSE, useful for creating constant false conditions in formulas and logical tests across Excel and Google Sheets.

=FALSE()

Generate a FALSE formula

Describe what you need. The generator will reach for FALSE where FALSE is the right tool, and tell you when it is not.

How to get a better answer
  • Name your columns by letter and by header: "column F (Net Value)" beats "the amount column".
  • State every condition, including the negatives — "not cancelled" changes the formula's shape.
  • Say where the data starts if it is not row 1, and whether it will grow.
  • Check the settings above match your spreadsheet: the wrong argument separator is a syntax error on your machine.

Arguments

ArgumentRequiredDescription

Returns

It returns a single logical FALSE value.

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Flag all campaigns as inactive

CampaignChannelSpendClicksConversions
Spring SaleEmail500025020
Summer BlastSocial800040035
Fall PromoSearch600030025
=FALSE()

Result: FALSE

The FALSE() function never looks at the surrounding data; it simply returns the logical constant FALSE. Placing the formula next to the campaign report lets you label every row as inactive without writing a separate condition for each campaign. Because FALSE is a single value, the result is the same for every row.

2. Create a static false test for IF

CampaignChannelSpendClicksConversions
Spring SaleEmail500025020
Summer BlastSocial800040035
Fall PromoSearch600030025
=IF(FALSE(), "Check", "Skip")

Result: Skip

Here FALSE() is used as the logical test inside IF. Since the test is always false, IF always returns the third argument, "Skip". This technique is handy when you want a placeholder decision that you can later replace with a real condition.

3. Combine FALSE with NOT to invert a condition

CampaignChannelSpendClicksConversions
Spring SaleEmail500025020
Summer BlastSocial800040035
Fall PromoSearch600030025
=IF(NOT(FALSE()), "Proceed", "Hold")

Result: Proceed

NOT(FALSE()) evaluates to TRUE, so the IF function takes the second argument, "Proceed", for every row. This pattern shows how FALSE can be flipped to produce a constant true outcome, useful when you need the opposite of a fixed false flag.

Common errors

Which FALSE error are you seeing?
FALSE returned an error#VALUE!
Remove the argument so the formula is simply =FALSE().
#NAME?
Correct the spelling to =FALSE().
#DIV/0!
Replace FALSE() with a non-zero number or wrap the expression in IFERROR to handle the error.
ErrorWhy it happensHow to fix it
#VALUE!Providing any argument to FALSE, such as =FALSE(1), exceeds its zero-argument definition.Remove the argument so the formula is simply =FALSE().
#NAME?Misspelling the function name, for example writing =FALS() instead of =FALSE().Correct the spelling to =FALSE().
#DIV/0!Using FALSE as a numeric zero in a division or negative exponent, e.g., =1/ FALSE() or =POWER(FALSE(),-1), triggers a division-by-zero error.Replace FALSE() with a non-zero number or wrap the expression in IFERROR to handle the error.

Tips and when to use something else

  • Use FALSE() when you need a constant false in logical formulas like IF(FALSE, …).
  • Pair FALSE with IF to return a specific value for all rows, e.g., =IF(FALSE, "Yes", "No").
  • When you need the opposite, use TRUE() instead of negating FALSE with NOT.
  • For multi-branch logic, consider SWITCH rather than stacking IF statements with FALSE conditions.

Related functions

IFThe IF function returns one value if a condition is true and another (or nothing) if it is false, letting you branch logic in a cell.TRUETRUE() returns the logical Boolean value TRUE, a constant that can be used in formulas wherever a true condition is needed.NOTNOT returns the opposite Boolean value of its logical argument, turning TRUE into FALSE and FALSE into TRUE for a single logical input.SWITCHSWITCH evaluates an expression and returns the matching result value, or a default if provided, simplifying multi-branch logic in a single formula.IFERRORIFERROR returns the result of a formula unless that formula generates an error, in which case it returns a user-specified alternative value.

Frequently asked questions

How do I use FALSE in an IF statement?
Place FALSE() as the logical test argument of IF. Because the test is always false, IF will always return the value you provide as the third argument. This is useful for creating placeholder outcomes that you can replace later.
Why does =FALSE() sometimes appear as 0 in my spreadsheet?
Both Excel and Google Sheets automatically coerce logical values to numbers when a numeric context is required. FALSE becomes 0 and TRUE becomes 1, so if you format the cell as a number you will see 0 instead of the word FALSE.
Can I combine FALSE with array formulas?
Yes. In a dynamic-array environment you can write =FALSE()*{1,2,3} which yields {0,0,0} because FALSE coerces to 0. However, the function itself still returns a single logical value, so the array behavior comes from the surrounding operation, not from FALSE.
Is there a difference between FALSE and the text "FALSE"?
Absolutely. FALSE (without quotes) is a logical constant that participates in logical calculations. "FALSE" (with quotes) is a text string and will not behave as a Boolean; functions that expect a logical value will treat it as non-numeric text, often resulting in errors or unexpected results.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator