FALSE Function

Returns the boolean value FALSE in Excel

Author: Patrick Curtis
Patrick Curtis
Patrick Curtis
Private Equity | Investment Banking

Prior to becoming our CEO & Founder at Wall Street Oasis, Patrick spent three years as a Private Equity Associate for Tailwind Capital in New York and two years as an Investment Banking Analyst at Rothschild.

Patrick has an MBA in Entrepreneurial Management from The Wharton School and a BA in Economics from Williams College.

Reviewed By: Sid Arora
Sid Arora
Sid Arora
Investment Banking | Hedge Fund | Private Equity

Currently an investment analyst focused on the TMT sector at 1818 Partners (a New York Based Hedge Fund), Sid previously worked in private equity at BV Investment Partners and BBH Capital Partners and prior to that in investment banking at UBS.

Sid holds a BS from The Tepper School of Business at Carnegie Mellon.

Last Updated:October 17, 2022

A FALSE function in Excel returns the boolean value FALSE. By nature, a logical and conditional function works great in combination with other logical functions such as IF, AND, OR, etc.

If you compare the function's library of Excel to music, we believe logical functions are similar to the Rock genre. They are the soul and spirit of the Excel community since no one could imagine their life without them.

I love Rock 'AND' Roll - Joan Jett & the Blackhearts, Should I stay 'OR' should I go? - The Clash, 'IF' only - Queens of Stone Age are some of the bangers without which we can't start our day, and the camouflaged functions without which we wouldn't be able to end office hours early.

The idea behind conditional statements is that Excel returns the result as TRUE or FALSE. So when the condition is met, the result is returned as TRUE, or the result returns as FALSE.

However, using the FALSE function in those statements would work similarly to the NOT function. For example, when you say NOT(TRUE), the function returns the result as FALSE, i.e., the opposite of the logical value.

Similarly, when you input a condition, say 1 > 2 = FALSE, whatever custom text we have assigned for the value_if_true argument will be the result rather than the value_if_false argument. 

This article will guide you in understanding the function's syntax, how to use it, and the various scenarios where you can 'rarely' use the function.

FALSE function - What is it?

The FALSE is categorized as a logical function that returns the boolean value the same as the function's name.

If you have used a lot of conditional statements, you might know that we can just directly input the boolean values as text strings, and Excel would still display the correct result.

So why do we even need a dedicated function?

Since there are a lot of other spreadsheet programs that a person might use based on availability and functionality, Microsoft wanted reports and data generated in 'those' spreadsheet programs to be compatible with their spreadsheet tool.

In short, Microsoft doesn't want any compatibility issues that could give you errors when you open the spreadsheet in Excel.

The function was introduced in the Excel version 2007 and has been ever-present in all the subsequent versions.

The syntax for the function:

=FALSE()

The function takes no arguments. Instead, you begin with an equal sign, type in the function name, complete the formula with parentheses, and smash the Enter key.

We do this when we say 'writing a function as a worksheet formula'. The result is a boolean value that stores the value equal to zero in Excel. 

The other method is:

  • Begin with the equal sign, type in the function name, and hit the enter key. No parenthesis is required.
  • Click on the Formulas tab > Logical drop-down menu > FALSE

When you click on the function, it will open up the dialog box as illustrated below:

Function dialog box

Finally, all you need to do is click on Ok, and the result in cell C3 will be 'FALSE'.

Examples of the function

Let's understand how the function works. This section will show examples of how to use the function.

a. Example #1

Suppose you must evaluate how many tests Jonathan has scored more than 80. The data looks as illustrated below:

Evaluating test scores

To get the result, we will use the formula =IF(C3>80, "Score is greater than 80",FALSE()) in cell D3, which should give us the result:

Result for the evaluation of test scores

Dragging down the exact formula up to D6, the result would be as illustrated below:

Final Test scores evaluation

On three different instances, we get the result as 'FALSE' as highlighted in our cells.

b. Example #2

There are two boolean values in Excel - TRUE and FALSE. The former takes in the value of 1, while the latter has a value equal to zero.

We can use this logic to make calculations such as addition or multiplications in Excel.

Boolean values in Excel

Let's say we multiply the values in column B by 10. The formula in cell C3 will be =B3*10 which will give us the result as illustrated below:

Values

Since TRUE equals 1, when we multiply the function by 10, the result will be similar to the number multiplied. On the other hand, as FALSE stores the value equal to 0, any number multiplied by the function will be equal to zero.

Similarly, when you add a number, say 2, to the function, then we will get the result:

Addition and Multiplication of Boolean values

The result for FALSE will always be equal to the number added to the function, whereas for TRUE, it will be one number greater than the numerical value added to the function.

c. Example #3

Suppose you work for an institutional investor and need to evaluate all the stock holdings in the portfolio. The portfolio looks as illustrated below:

Evaluating stocks portfolio

We need to identify what stocks have holdings of less than $2000. For this, we will use the formula =IF(C3>2000,"Holdings are greater than $2000",FALSE()), which will give us the result:

Result on stocks portfolio

In cells D4 and D7, we get the result as FALSE, where Apple Inc has a holding of $580 while Meta Inc has a holding of $1,922 respectively.

d. Example #4

You can also use the combination of IF, AND, and FALSE functions to evaluate multiple conditions.

Suppose that for the dataset below, we want to match 'Nvidia Inc' stock purchased for more than $ 171.

Evaluating based on multiple criteria

To find a price paid higher than $171 for Nvidia Inc, we will use the formula =IF(AND(B3="Nvidia Inc", C3>171),"Paid higher than $171",FALSE()) which will give us the result as illustrated below:

Function in multiple criteria

All cells except cell D5 return the result as FALSE since only cell D5 fulfilled both our conditions.

e. Example #5

If you can use the AND function, then it's pretty obvious you can also use the OR function.

We believe these functions represent the yin and yang of Excel and work great with our compatibility function.

Suppose that you have the marks scored by students in their two different examinations.

Example

If the student has scored less than 35 in either of the exams, then they must re-appear for the same. 

The formula that we can use to find the status of the students is =IF(OR(C3<35,D3<35),"Re-Appear for Exam",FALSE()), which will give us the result:

Results

We believe you would rarely use this function in your career, but it never hurts to have additional knowledge, right?

TRUE vs. FALSE function

The TRUE function returns the boolean value TRUE while its counterpart returns the boolean value FALSE. We saw that the latter does not have a syntax. Is it the same case with the TRUE function as well?

If you thought yes, then you are right.

The function does not have syntax, and you can use it directly by beginning with an equal sign, followed by the function name, and then ending the formula with the parenthesis.

Again, there are two more methods to use the function:

1. In this method, you don't need the parenthesis at the end of the formula. All you need is =TRUE, and press Enter on the keyboard.

TRUE formula in Excel

2. The other method is from the function's library, where you need to access the function by clicking on the Formulas tab > Logical drop-down menu > TRUE.

This will open up the dialog box as illustrated below:

TRUE function dialog box

Now, all you need to do is click on Ok, and the selected cell will consist of the boolean value TRUE.

Suppose that you have the examination scores for Mike Byers in different subjects:

Example for the TRUE function

The idea is to determine what scores are higher than 80 and in which subjects Mike scored less than 80.

We will use the combination of IF, TRUE and FALSE functions to find the result. The formula will be =IF(C3>80,TRUE(),FALSE()) which will give the result as:

Results

If you use the TRUE function along with NOT, Excel will return the result as FALSE wherever the condition is fulfilled.

In the same dataset, let's say we want to find all the subjects with scores greater than 80.

We can twist the formula by including the NOT function so that the formula becomes =IF(NOT(C3<80),"Greater than 80",FALSE()) which will give the result:

Customized text strings instead of boolean values

The two significant changes we made in the formula include the NOT function and flipping the comparison operator to less than (<), which gives us our result.

Key Takeaways

  • TRUE and FALSE are categorized as logical functions and return a boolean value the same as the function's name.
  • The TRUE function stores the value as 1, while the FALSE stores the value as 0.
  • The FALSE function without the parenthesis gives the same result.
  • You can use the FALSE function in addition or multiplication operations. The result for multiplication will always be zero, while for addition and subtractions, it will be equal to the number added or subtracted.
  • The function provides compatibility with other spreadsheet applications and isn't compulsory to use if you primarily work in MS Excel.
  • Both the boolean functions collaborate well with other logical functions, such as OR, AND, IF, IFS, etc., to make data analysis easier.

Researched and authored by Akash Bagul | LinkedIn

Free Resources

To continue learning and advancing your career, check out these additional helpful WSO resources: