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.
