What it Returns

It returns a logical argument which is the reverse of the logical argument used within the NOT function. For example, =NOT(TRUE) returns FALSE and =NOT(FALSE) returns TRUE.



Input Arguments

logical – A value or expression that can be evaluated to TRUE or FALSE.

Additional Notes:

You can check expression with NOT function that evaluates to TRUE or FALSE. For example, =NOT(1+1=2) would return FALSE.

Examples – Using Excel NOT Function

Here are three example of using the Excel NOT Function:

#1 Converting TRUE to FALSE / FALSE to TRUE

It converts TRUE to FALSE and FALSE to TRUE. The argument within the function can also be a result of some other function(s) that results in TRUE/FALSE.

#2 Using with Formula Result

If used with a formula result (that returns TRUE/FALSE), it converts TRUE to FALSE and FALSE to TRUE. In the above example, the value is A2 is compared with a number (that returns TRUE if the condition is met, else FALSE), and NOT function is used on the result of the comparison.

#3 Using with Numbers

In Excel, 0 denotes FALSE and any other number denotes TRUE. Excel NOT function converts 0 (which is FALSE) to TRUE and any other number to FALSE.

Excel NOT Function – Video Tutorial

Related Excel Functions:

Excel AND Function. Excel OR Function. Excel IF Function. Excel IFS Function. Excel IFERROR Function. Excel FALSE Function. Excel TRUE Function.