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)
Excel FALSE Function: Syntax & Arguments
The FALSE function returns the logical value false
As we can see from the picture above the FALSE function doesn’t take any argument in its parameter.
- 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
- 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
- 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.
So, our scenario will be like this:
Step 1: Enter the formula in cell H6
- 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() )
- 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
The syntax of NOT function is:
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.
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.