Search

# 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

## Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster