July 31, 2021

NOT function in Google Sheet

In this lesson we will learn how the NOT function works in Google Sheet. The NOT function is used when you want to reverse the value of a logical argument (TRUE/FALSE). It returns TRUE/FALSE which is the reverse of the logical argument used within the NOT function.

=NOT(logical)
  • logical – A value or expression that is evaluated to TRUE or FALSE.

Let’s understand with a simple example. We have used the below formula in cell B2.

=NOT(A2>A3)

Here A2=5 and A3=10, hence A2>A3 is FALSE but the NOT function reverses it and returns TRUE in cell B2.

Note :

In Google Sheet, 0 denotes FALSE and any other number(positive or negative) denotes TRUE. While using with numbers, the NOT function converts 0 (which is FALSE) to TRUE and any other number to FALSE. For example,

=NOT(0) returns TRUE

=NOT(1) returns FALSE

=NOT(2) returns FALSE

=NOT(500) returns FALSE

=NOT(-23) returns FALSE

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

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

You can check here to know how the OR function works in Google Sheet.

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

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

Leave a Reply

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