Flipping Logic With NOT

Sometimes it is easier to describe what you do not want than what you do. You might say show everyone who is not from the East region, or flag any order that is not paid.

The NOT function reverses a logical value. If something is TRUE, NOT makes it FALSE. If it is FALSE, NOT makes it TRUE.

It is the simplest logical function, taking just one condition, but it unlocks cleaner ways to express many rules.

Unlike AND and OR, the NOT function takes exactly one argument:

• logical a single condition or value that evaluates to TRUE or FALSE

It returns the opposite. There is no second argument and no comma list. Whatever you put inside, NOT simply flips it.