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

**Table of Contents**hide

## Download Practice Workbook

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

## 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 to Use 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**.

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

- Type the following function in cell
**E4**.

`=FALSE()`

- Drag down the
**Fill Handle**.

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

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

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

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

- But if you divide the sales values by the function like the following

`=C11/FALSE`

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

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

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

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

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

- 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’ **ID**s, **Name**s, and subject-wise **mark**s. 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.

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

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

## How to Use 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**.

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

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

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