How to Use NOT Function in Excel: Simple Guide

In Excel, use the NOT function to reverse a logical value or condition. It returns TRUE if the input is FALSE, and FALSE if the input is TRUE. The syntax is =NOT(logical) where logical is any condition or value.

Syntax

The NOT function has a simple syntax:

• logical: This is the value or condition you want to reverse. It can be a logical expression like A1>10 or a cell reference containing TRUE or FALSE.

The function returns the opposite logical value.

excel

=NOT(logical)

Example

This example shows how NOT reverses a condition. If cell A1 contains 5, the formula =NOT(A1>10) checks if A1 is NOT greater than 10.

excel

=NOT(A1>10)

Output

TRUE

Common Pitfalls

One common mistake is using NOT on values that are not logical (TRUE or FALSE). For example, =NOT(5) returns FALSE because 5 is interpreted as TRUE. Always use NOT with logical expressions or cells containing TRUE/FALSE.

Another pitfall is forgetting that NOT only reverses TRUE/FALSE, it does not perform arithmetic or text negation.

excel

=NOT(5)  <em>Returns FALSE because 5 is treated as TRUE</em>
=NOT(A1>10)  <em>Right - reverses TRUE/FALSE</em>

Quick Reference

Usage	Description	Example
=NOT(logical)	Reverses TRUE to FALSE or FALSE to TRUE	=NOT(A1>10)
Use with logical expressions	Works with comparisons like >, <, =, etc.	=NOT(B2="Yes")
Use with logical cells	Works if cell contains TRUE or FALSE	=NOT(C3)

Key Takeaways

Use =NOT(logical) to reverse TRUE or FALSE values in Excel.

The argument must be a logical expression or a cell with TRUE/FALSE.

NOT returns TRUE if the input is FALSE, and FALSE if the input is TRUE.

Avoid using NOT on numbers or text directly; it may cause unexpected results.

Combine NOT with other functions for flexible logical tests.