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

### Syntax

=NOT(logical)

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

DOWNLOAD FREE EXCEL EBOOK

51 Excel Tips to Save Time & Increase Productivity

(22,000+ Enthusiasts have Already Downloaded)