How to Use NOT Function

The NOT function reverses the value of its argument. When the argument is true, the NOT function returns false; when argument is false, the NOT function returns true.

Formula:

= NOT(logical)

Explanation:

"Logical" is required, the argument that can be evaluated to TRUE or FALSE.

In cell C2, argument A2=1 is true, the NOT function (A2=1) reverse the logic and returns FALSE;

In cell C3, argument A3=1 is false, the NOT function (A3=1) reverse the logic and returns TRUE.

Download: NOT Function

Leave a Reply