# Excel NOT Function | Formula Examples + FREE Video

## Excel NOT Function (Example + Video)

### When to use Excel NOT Function

It can be used when you want to reverse the value of a logical argument (TRUE/FALSE).

### 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.

=NOT(logical)

### Input Arguments

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

• 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: FREE EXCEL BOOK