The NOT function, one of many EXCEL logical functions, is used to evaluate a single logical condition, passed as an argument to the function. It will return the opposite of that argument. I.e.:

- If the evaluated logical condition is TRUE, the function will return FALSE.
- If the evaluated logical condition is FALSE the function will return TRUE.

**Syntax**

NOT(logical)

Logical is a condition that evaluates to TRUE or FALSE.

**Examples**:

A1 = 6

B1 = 10

=NOT(A1>5) : returns FALSE.

= NOT(A1>10): returns TRUE.

=NOT(A1=B1): returns TRUE.

You can nest the NOT function within another logical function as follows:

=IF(NOT(A1=B1) ;”Valid numbers”;”Invalid numbers”)

If you put this formula in C1 for example, and A1 and B1 have the values shown above, then C1 will have the value: “Valid numbers”, because the NOT function will evaluate to TRUE.