How to Use FALSE Function in Excel (7 Easy Examples)

The FALSE function in Excel is one of the logical functions in Excel which gives FALSE as output. Using this function, we can declare the cell value as FALSE. This function is used widely in the IF function to print FALSE depending on various conditions. In this article, I will share the complete idea of how the FALSE function works in Excel independently and then with other Excel functions.


Download Practice Workbook


FALSE Function in Excel (Quick View)

quick view of Excel FALSE Function


Excel FALSE Function: Syntax & Arguments

⦿ Function Objective

The FALSE function gives us the word FALSE to make remarks or compare with others.

⦿ Syntax

=FALSE()

As we can see from the picture above the FALSE function doesn’t take any argument in its parameter.

Note:

  • Logical expressions will automatically generate TRUE and FALSE
  • We can call the function “compatibility function” as we can use it for comparing with other worksheets.

⦿ Return Value

The FALSE function returns the logical value FALSE.

⦿ Version

The FALSE function has been introduced in Excel 2000 version and is available for all versions after that.


7 Examples of Using FALSE Function in Excel

Here, we have a dataset of some products with their last two years’ total sales. Using this dataset, we will explain most of the following examples to demonstrate the uses of the FALSE function.

dataset for Excel FALSE Function

For making this article, we are using Microsoft Excel 365 version, you can use whatever you want.


Example-1: Getting Output as FALSE by Using Only FALSE Function

Here, we have seen that none of the sales values in Columns C and D are greater than 500,000 and so we want to put down FALSE in column E using the FALSE function. This function will only give us the logical value FALSE.

Applying Excel FALSE Function

  • Type the following function in cell E4.
=FALSE()

As a result, we are getting FALSE as a result in column E.

Result of Excel FALSE Function


Example-2: Multiplying, Dividing, Adding, and Subtracting Different Numbers with FALSE Function

Here, we will be adding, subtracting, multiplying, and dividing the values of column C with the FALSE function and will see the results. The FALSE function is similar to zero numerically.

Multiplying, Dividing, Adding, and Subtracting Different Numbers with FALSE Function in Excel

  • Use the following formula to add the values with the FALSE function.
=FALSE()+C4

Here, we are getting results similar to the sales values in 2020 as the FALSE function is giving zero.

  • Secondly, we will try to subtract the FALSE function from the sales values using the following formula.
=C4-FALSE()

In this case, also, we are getting results similar to the sales values in 2020 as the FALSE function is giving zero.

  • But if you subtract the sales values from the function like the following
=FALSE()-C11

Then, you will get a negative value.

  • Thirdly, we will multiply the sales values with the FALSE function.
=C4*FALSE()

The resultant values will be zero as we are multiplying the sales values with 0.

multiply

  • Finally, we will divide the FALSE function by the sales values.
=FALSE()/C4

The resultant values will be zero as we are dividing 0 by the sales values.

Dividing by Excel FALSE Function

  • But if you divide the sales values by the function like the following
=C11/FALSE

Then, you will get the #DIV/0! error.

divide


Example-3: Using IF and FALSE Functions to Compare Two Numbers in Excel

Now we will compare the sales values between two years and find out if the sales of each product increased or not.

IF & FALSE Functions in Excel

  • Type the formula in cell E4.
=IF(D4>C4,"True",FALSE())

Formula Explanation

  • Here inside the IF function, D4>C4 is our logical condition.
  • We are checking if the sales in column D are greater than the sales in column C or not. If the result is yes then we will print the “True” message otherwise the FALSE function will return FALSE.
  • Drag down the Fill Handle.

Finally, you will get True for the sales values which are increased from 2019 to 2020, and FALSE for the sales values which are not increased.

Compared Numbers with Excel FALSE Function

Read More: How to Use IF Function in Excel (8 Suitable Examples)


Example-4: Applying IF and FALSE Functions to Compare Strings

Now let’s say we have the same product list along with their delivery status. The status could be Delivered, Shipped, Processing, or Pending. Now we will find out the products which are already delivered.

comparing strings with Excel FALSE function

  • Type the formula in cell D4 and copy it down up to D11
=IF(C4="Delivered","True",FALSE())

Formula Explanation

  • C4="Delivered" is the condition.
  • "True" will be printed if the condition is true.
  • The FALSE() function will return FALSE if the condition is false.

Finally, you will get True for the delivered condition, and FALSE for the shipped and processing conditions.


Example-5: Combining COUNTIF and FALSE Functions

Now for the previous example, we will count the number of incomplete deliveries. We need to count the cells where Delivery Completed is equal to FALSE and so we will use the COUNTIF function additionally. For more details about this function, you can check these links.
COUNTIF Multiple Ranges Same Criteria in Excel
COUNTIF between Two Cell Values in Excel (5 Examples)

So, our scenario will be like this:

Combining COUNTIF and FALSE Functions

  • Enter the formula in cell C13.
=COUNTIF($D$4:$D$11, FALSE())

Formula Explanation

  • $D$4:$D$11 this is the range from where we will find the FALSE.
  • FALSE () will be used for comparing values. From the range, we will compare cell values with this function and count the FALSE.


Example-6: Using IF, AND, SUM, and FALSE Functions to Determine Pass and Fail

Now let’s move to a complex example. Let’s assume we have a dataset of some students’ IDs, Names, and subject-wise marks. Let’s say the passing threshold value is 50. Now if any student gets less than 50 marks on any subject then it will be considered a failure and print FALSE as a message. Otherwise, it will show the average marks.

Using IF, AND, SUM, and FALSE Functions to Determine Pass and Fail

  • Enter the formula in cell H4 and copy it down to H12.
=IF(AND(D4>=50, E4>=50, F4>=50, G4>=50), SUM(D4:G4)/4, FALSE() )

Formula Explanation

  • Here, SUM(D4:G4)/4 is calculating the average marks for each student. The SUM function is for calculating the sum of each row and as we have 4 subject marks that’s why the summed value is divided by 4.
  • AND(D4>=50, E4>=50, F4>=50, G4>=50) will use the AND function to check if there is any subject column that is less than 50. If any of the values is less than 50, then the whole return value will be FALSE, otherwise, the average marks will be returned.
  • Lastly, the FALSE() function is used to print FALSE if the condition is false.

Eventually, we will get the obtained marks for each student who has received marks greater than 50, the students who have not received this minimum mark will get FALSE here.

Read More: How to Use AND Function in Excel (5 Suitable Examples)


Example-7: Finding FALSE Values

In this section, we will see how to find out the FALSE value from any cell. For this, we will use the same dataset used in Example 3. Here we will not directly use the FALSE function. We will use the NOT function to find the FALSE value from cells.

Finding FALSE Values

  • Enter the formula in cell F4 and copy it down up to F11.
=NOT(E4)

Formula Explanation

The syntax of the NOT function is:

NOT(logical)
Logical —–> This is a required argument. The condition which you want to choose should be selected here.

In this way, we are getting TRUE for the cells which contain FALSE and it is representing that the sales have decreased.

Read More: How to Use NOT Function in Excel (With 8 Examples)


Things to Remember

  • The FALSE function always returns a logical FALSE
  • FALSE & FALSE() both are similar.
  • The function does not require any argument.
  • It has a numeric value of 0.

TRUE and FALSE Functions in Excel

We can use the combination of the TRUE and FALSE functions to do the same task as in Example 3.

TRUE and FALSE functions

  • Enter the formula in cell E4 and copy it down up to E11
=IF(D4>C4,TRUE(),FALSE())

Formula Explanation

  • Here inside the IF function, D4>C4 is our logical condition.
  • We are checking if the sales in column D are greater than the sales in column C or not. If the result is yes then the TRUE function will print the TRUE message otherwise the FALSE function will return FALSE.

Finally, you will get TRUE for the sales values which are increased from 2019 to 2020, and FALSE for the sales values which are not increased.


Conclusion

This is all about the FALSE function in Excel and its different applications. If you have any other method of utilizing this function, then please feel free to share it with us.


Related Articles

Md. Abdullah Al Murad

Md. Abdullah Al Murad

Hello! Welcome to my Profile. Currently, I am working and researching Microsoft Excel, and here I will be posting articles related to this. My last educational degree is BSc, and my program was Computer Science and Engineering from American International University-Bangladesh. I am a Computer Science graduate with a great interest in research and development. Always try to gather knowledge from various sources and try to make innovative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo