False In Excel

Article byWallstreetmojo Team
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

What Is FALSE Function In Excel?

The FALSE function in Excel is a logical function that returns “FALSE” as an output when used in a blank cell. This function also does not take any arguments similar to the TRUE function in Excel. Instead, it is used with the other conditional functions, such as the IF function, to return a “FALSE” as a value if the condition is met or not.

For example, consider the below example showing a value in cell B1.

Now, let us find whether the value is more than 1000 or not using FALSE function in Excel.

The steps are:

Step 1: First, enter the function, =B1>1000

Step 2: Next, press Enter.

We can see the result as shown in the below image.

Likewise, we can use FALSE function in Excel.

Key Takeaways

  • FALSE function in Excel provides a “FALSE” result when it is utilized in an empty cell. It is usually utilized with other conditional functions, such as IF, to return a “FALSE” value based on a condition.
  • This function in Excel is equivalent to 0 and allows for mathematical operations. If any number is multiplied by this function, it will result in zero.
  • The FALSE function returns “FALSE”. FALSE and FALSE() are the same, with a 0 value. No arguments are needed for the function.

FALSE Formula In Excel

Below is the FALSE formula in Excel.

FALSE Formula in excel

The FALSE formula in Excel requires no arguments.

One may also enter the word “FALSE” directly into any cell or formula, and Excel will interpret this as the logical value “FALSE.”

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

How To Use False Excel Function?

It is mostly used in conjugation with other functions, such as conditional functions, which do different things depending on whether a certain criterion is met. For example:

  1. An employer will increase your monthly payment if you have reached a particular target.
  2. You will get a discount coupon only when you have done shopping for more than $5,000.

The FALSE function in Excel is equivalent to the number 0. We can perform all the mathematical operations with this function. If we multiply any number with this function, it will return zero.

You can download this FALSE Function Excel Template here – FALSE Function Excel Template

Examples

Example #1

To obtain a FALSE in a cell, we must enter the FALSE function :

=FALSE()

FALSE Function Example 1

Press the “Enter” key.

The function will return “FALSE.”

FALSE Function Example 1-1

We can use the function along with mathematical operations, in which the function takes the value 0. Let us see an example.

Example #2

Suppose we multiply a number, e.g., 10, with the function. The syntax will be:

=FALSE * 10 or FALSE() * 10

FALSE Example 2

Press the “Enter” key.

The function will return 0.

FALSE Example 2-1

Similarly, if we add the number with the function,

Syntax: =FALSE + 10 or FALSE() + 10

FALSE Example 2-2

Consequently, it will return 10 (as 0+10=10).

FALSE Example 2-3

Example #3

Suppose we have a number in cell C3, and we want to check whether the number is greater than 50.

FALSE Example 3

We can use the following syntax to check the condition.

=C3 > 50

FALSE Example 3-1

The syntax will return “FALSE”.

FALSE Example 3-2

Similarly, we can check if the number in C3 is less than 10 using the syntax below.

=C3 < 10

FALSE Example 3-3

Again, this returns “FALSE.”

FALSE Example 3-4

The FALSE function is most widely used with conditional functions. Let us see an example of using a FALSE function with an IF condition.

Example #4

Suppose different employees in your company sell the same item. Then, depending on the number of items an employee sells in a month, we will decide whether to give the employee a bonus or not. For example, five employees’ number of items sold (A4: A8) is shown in B4: B8.

FALSE Example 4

If an employee sells equal to or more than 1,000 goods, he will get a bonus. So, the syntax for the first employee would be:

=IF(B4>=1000, TRUE, FALSE)

FALSE Example 4-1

It returns “TRUE” when the employee has reached the target and “FALSE” when they have not.

FALSE Example 4-2

The IF function works on the logical values “TRUE” and “FALSE.” We may note here that if we do not provide the value_if_false in the IF function, it will automatically return “FALSE,” as shown below.

FALSE Example 4-3

Example #5

Suppose you run a delivery outlet. In this, you maintain a sheet of order numbers and their delivery status, as shown below.

FALSE Example 5

So, if the status is “Delivered,” the order is complete. We can check whether an order is complete or not using the FALSE statement. For example, for the first order (given in A4:B4), we can use the syntax:

=IF(B4=” Delivered”, TRUE, FALSE)

FALSE Example 5-1

Expanding the function to the rest of the cells will return the completion status in “TRUE” or “FALSE.”

FALSE Example 5-2

We may also calculate the number of pending orders using the function COUNTIFUsing The Function COUNTIFThe COUNTIF function in Excel counts the number of cells within a range based on pre-defined criteria. It is used to count cells that include dates, numbers, or text. For example, COUNTIF(A1:A10,”Trump”) will count the number of cells within the range A1:A10 that contain the text “Trump” read more as:

COUNTIF(C:C,FALSE)

The function will count the number of times the value “FALSE” occurs in column C.

FALSE Example 5-3

Since the number of “FALSE” in this example is 3, it will return 3.

Example 5-4

Instead of C:C, we may also use C4:C8 since the values are in these cells only. However, the entries may keep increasing with time. Therefore, it will not be required to change every time an entry is added for C: C.

Example #6

Suppose we have a list of students and their marks in 5 different subjects.

Example 6

If any cell for marks (C4: G23) is left blank, it specifies that the student has not given the exam. If the marks are less than 40, the student is considered to fail. In both cases, the student’s final result is not declared. So now, we can calculate the percentage of the students who have successfully passed all the subjects but not those who could not.

We may use the following syntax:

=IF(AND(C4>40, D4>40, E4>40, F4>40, G4>40), SUM(C4:G4)/5, FALSE )

In this syntax,

  1. AND(C4>40, D4>40, E4>40, F4>40, G4>40)

It will return “TRUE” if the student has scored marks greater than 40 in all the five subjects. Else, “FALSE.”

  1. IF(AND(…), SUM(C4:G4)/5, FALSE )

which implies

=IF(TRUE,SUM(C4:G4)/5, FALSE )   or  =IF(FALSE,SUM(C4:G4)/5, FALSE )

If AND(…) returns “TRUE,” the IF function will return the percentage of marks the student has secured, SUM(C4: G4)/5.

If AND(…) returns “FALSE,” the IF function will also return “FALSE.”

Example 6-1

We can drag it to the rest of the cells and will get the final output as:

Example 6-2

Since it is a logical value, “TRUE” is the opposite of “FALSE.” Therefore, if we type NOT(FALSE), it will return “TRUE.” See the example below.

Example #7

Suppose we have a list of interested participants for the campaign and the information on whether they have registered or not, as shown below.

Example 7

If it says, “Ashwin has registered,” we will say “TRUE.” However, if it says, “Ashwin has not registered,” we will say “FALSE.” We may change “TRUE” to “FALSE” by using the NOT function in excelUsing The NOT Function In ExcelNOT Excel function is a logical function in Excel that is also known as a negation function and it negates the value returned by a function or the value returned by another logical function.read more.

For the first name in the list, the syntax will be:

=NOT(B4)

Example 7-1

It will return “FALSE”.

Example 7-2

As shown below, we can drag it to the rest of the cells. We may get the final output for the complete list.

Example 7-3

Important Things To Note

  • The function returns the logical value “FALSE.”
  • The FALSE and FALSE () both are identical.
  • The FALSE function has a value of 0.
  • There are only two logical values: TRUE and FALSE. TRUE is the opposite of FALSE.
  • The function does not require any argument.

Frequently Asked Questions

1. What causes false in Excel formula?

If your formula is FALSE, that is because the values in columns do not meet the conditions mentioned in the statement; however, if the formula is partially correct unless it was intended to be incorrect.

2. Explain the use of FALSE function with an example.

Consider the below example showing a value in cell B1.



Now, let us find whether the value is more than 5000 or not using FALSE function in Excel.

The steps are:

Step 1: First, enter the function, =B1>5000
Step 2: Next, press Enter.

We can see the result as shown in the below image.



Likewise, we can use FALSE function in Excel.

3. How do I change 0 to false in Excel?

In Microsoft Excel, you have the option to change the value of a cell from 0 to false. This can be accomplished by either typing “false” (without quotes) directly into the cell or by using a formula that evaluates to false. An example of such a formula could be “=1=2”. By using either of these methods, you can easily convert a numeric value to a boolean value in Excel.

Recommended Articles

This article has been a guide to the FALSE Function in Excel. We discussed the FALSE formula in Excel, using the FALSE function and Excel examples, and downloadable Excel templates. You may also look at these useful functions in Excel: –

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *