January 19, 2021

FALSE function in Excel

In this lesson we will learn how the FALSE function works in Excel. The FALSE function doesn’t take any input arguments and returns the logical value FALSE.

=FALSE()

Let’s understand with a simple example. In the below table, the FALSE function is used in cell B1 evaluating the following condition.

=IF(AND(A2>0,A2<100),"Approve",FALSE())

In this example, since the condition is not met as the content of cell A2 is 150 and 150>0 but 150 is not less than 100. So it makes the AND function to return 0, which in turn triggers FALSE() function inside IF and results FALSE in cell B2.

In the same example we just changed the price value as 50 in cell A2 and this will make both conditions of the AND function to return true which in turn makes the result of the AND function as 1 and in this case, since the conditions are met, it returned “Approve” as the result in cell B2.

Notes :

  • =FALSE and =FALSE() both would return the same logical value as FALSE.
  • In terms of value, a FALSE is a 0 and a TRUE is a 1 in Excel.

For example: =FALSE+TRUE would be 1 and =FALSE+FALSE would be 0.

You can also check here to understand how the FALSE function works in Google Sheet.

You can also check here to understand how the TRUE function works in Google Sheet.

You can also check here to understand how the TRUE function works in Excel.

Leave a Reply

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