Summary

The Excel FALSE function returns the logical value FALSE. Like TRUE(), it is a very small function, but it helps explain how Excel handles logical values in formulas, decisions, and some calculations.

In many real formulas, FALSE appears as the result of a comparison such as =A1=0 or =B2="Yes". The FALSE function is most useful when you want to return that value explicitly, or when you want to understand how FALSE behaves in logical formulas and lookup settings.

Syntax

=FALSE()

The FALSE function takes no arguments. Microsoft also notes that you can type the word FALSE directly into a cell or formula and Excel will understand it. The function version is still helpful when you want a clear, explicit formula.

Arguments

• No arguments - FALSE does not take any inputs.

If you see FALSE inside another formula, it is often being used as a fixed logical result rather than something calculated directly by this function.

FALSE vs Related Functions

FALSE is easiest to understand when you compare it with the other logical building blocks around it.

FALSE also appears in some older lookup formulas. For example, in VLOOKUP, a final argument of FALSE asks for an exact match rather than an approximate one.

Using FALSE

A direct =FALSE() formula is useful when you want to create a simple logical flag or force part of a test into a false state. That can help while building or checking formulas, or when you want an explicit off value in a small model.

FALSE also matters because of how Excel treats it in calculations. In many formulas, FALSE behaves like 0. That means multiplying a number by FALSE returns zero. This is one of the simplest ways to understand how logical values can affect math in Excel.

It is also important to separate logical FALSE from the text string "FALSE". If you put FALSE in quotes, Excel treats it as text, not as a logical value. That difference matters when the result will be used in later formulas, lookups, or filters.

Example 1 - Return FALSE Directly

This is the most basic use of the function.

=FALSE()

The formula returns the logical value FALSE. This is useful when you want to create a fixed logical flag or test how another formula reacts to a FALSE input.

Example 2 - Get FALSE from a Comparison

Many formulas return FALSE without using the FALSE function directly.

=10=20

This returns FALSE because the two sides are not equal. It shows that comparisons naturally produce logical results in Excel, which is why FALSE often appears as the output of another formula rather than from =FALSE() itself.

Example 3 - Return FALSE from an IF Formula

FALSE can also be used as the explicit result of a condition.

=IF(A1="",FALSE(),TRUE())

If A1 is empty, the formula returns FALSE. Otherwise it returns TRUE. This kind of formula can be used to create ready/not-ready, present/missing, or active/inactive flags.

Example 4 - Use FALSE in Simple Multiplication

This example shows how FALSE behaves in math.

=100*FALSE()

Because FALSE behaves like 0 here, the result becomes 0. This helps explain why logical values can sometimes be used as switches in numeric formulas.

Conclusion Recap

• Core idea: FALSE() returns the logical value FALSE.
• No inputs: The function takes no arguments.
• Common reality: FALSE is often produced automatically by comparisons and logical formulas.
• Math behavior: In many formulas, FALSE behaves like 0.
• Important distinction: FALSE is logical, while "FALSE" is text.
• Lookup note: FALSE is also commonly used as the exact-match setting in older lookup formulas such as VLOOKUP.