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.

**Table of Contents**hide

## Download the Practice WorkBook

**FALSE Function in Excel (Quick View)**

**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.

**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.

**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.

**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.

**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:

**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.

**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.

**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.

**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.

**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.

**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.