How to Use FALSE Function in Excel (With 5 Easy Examples)

Overview of FALSE function

The FALSE function in Excel is one of the logical functions in Excel which gives FALSE as output. Using this function, we 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 the Practice WorkBook

FALSE Function in Excel (Quick View)

Overview of FALSE function

Excel FALSE Function: Syntax & Arguments

Excel FALSE Function Syntax & Arguments

Summary

The FALSE function returns the logical value false

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 results.
  • This function is classified as a “compatibility function“, required only for compatibility with other spreadsheet purposes. There is no requirement to apply the FALSE function if you are creating a spreadsheet in Excel.

How to Use the FALSE Function in Excel (5 Examples)

Example 1: Comparing Two Numbers Using IF and FALSE Function

Let’s have a dataset of some products with their last two years’ total sales. Now we will compare and find out if the sales of each product are increased or not.

Comparing Two Numbers Using IF and FALSE Function

Step 1: Enter the formula in cell E4 and copy it down up to E11

=IF(D4>C4,"True",FALSE())

Formula Explanation

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

Formula using IF and FALSE function

Example 2: Comparing Strings Using IF and FALSE Function

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

Comparing Strings Using IF and FALSE Function

Step 1: Enter the formula in cell D4 and copy it down up to D11

=IF(C4=”Delivered”,”True”,FALSE())

Formula Explanation 

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

Formula using IF and FALSE Function

Example 3: COUNTIF and FALSE Function

Now for the previous example, we will count the number of incomplete deliveries. For this, we need to count the cells where Delivery Completed is equal to FALSE. For this, we need to 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:

COUNTIF and FALSE Function

Step 1: Enter the formula in cell H6

=COUNTIF(D4:D11,FALSE())

Formula Explanation

  • D4:D11 this is the range from where we will find the FALSE values.
  • FALSE () this is the comparing value. From the range, we will compare cell values with this function’s FALSE return value and count them.

 Enter formula using COUNTIF and FALSE

Example 4: Determine Pass and Fail Using IF, AND, SUM, and FALSE Function

Now let’s move to a complex example. Let’s assume we have a dataset of some student’s ID, Name, and their 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 as a failure and print FALSE as a message. Otherwise, it will show the average marks.

Determine Pass and Fail Using IF, AND, SUM, and FALSE Function

Step 1: Enter the formula in cell G4 and copy it down up to G12

=IF(AND(C4>=50, D4>=50, E4>=50, F4>=50), SUM(C4:F4)/4, FALSE() )

Formula Explanation

  • Here, SUM(C4:F4)/4 this portion 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(C4>=50, D4>=50, E4>=50, F4>=50) here AND function is used to check if there is any subject’s column that is less than 50. If any of the conditions is false then the whole return value will be false, otherwise, it is true.
  • Lastly, FALSE() this function is used to print FALSE if the condition is false.

Enter formula using AND IF SUM and FALSE function

Example 5: Find False Value

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 method 1. Here we will not directly use the FALSE function. We will use the NOT function to find the FALSE value from cells.

Find False Value

Step 1: Enter the formula in cell F4 and copy it down up to F12

=NOT(E4)

Formula Explanation

The syntax of NOT function is:

NOT(logical)

Logical —–> This is a required argument. Here the argument should be a logical or numerical value. If the given logical argument is a numeric value, zero is handled as the logical value FALSE and any other numeric value is handled as the logical value TRUE.

Formula using NOT function

Things to Remember

  • The FALSE function always returns a logical FALSE value.
  • FALSE & FALSE() both are identical.
  • The function does not require any argument.
  • The numeric value of this function is 0.

Conclusion

This is all about the FALSE function and its different applications. Overall, in terms of working with time, we need this function for various purposes. I have shown multiple methods with their respective examples but there can be many other iterations depending on numerous situations. If you have any other method of utilizing this function, then please feel free to share it with us.


Further Readings

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