November 25, 2020

FALSE function in Google Sheet

The FALSE function returns the logical value FALSE in both Excel & Google Sheet. It doesn’t take any input arguments.

=FALSE()

In the example below, FALSE function is used in evaluating a condition. 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.

If the condition is met, it simply returns “Approve” as the result.

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.

Leave a Reply

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