In this lesson we will learn how the NOT function works in Excel. 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.
- 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.
Here A2=5 and A3=10, hence A2>A3 is FALSE but the NOT function reverses it and returns TRUE in cell B2.
In Excel, 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