Excel function · Logic

NOT

Turns TRUE into FALSE and FALSE into TRUE.

What it does

NOT reverses a test. It's useful when the opposite of what you want is easier to describe, like stock that is not at least 10.

=NOT(logical)

Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ,

Stock is reordered when there are fewer than 10 left. There are 8. Reorder?

	A	B
1	In stock	Reorder?
2	8	TRUE

The formula in B2:

=NOT(A2>=10)

Result: TRUE

For 8, the test A2>=10 is FALSE, and NOT turns that into TRUE: time to reorder.

Giving it several tests. NOT takes exactly one; combine tests with AND or OR first.
Using NOT where a plain comparison is clearer. NOT of A2>=10 is simply "A2 is less than 10", which is easier to read later.

Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.