NOT
Definition: NOT is a function that returns the opposite of a logical value.
Syntax: =NOT(logical)
Situation: This formula is appropriate when you need to get the opposite of a logical value.
Example: If you have a logical value TRUE, the formula =NOT(TRUE) can be used, which returns FALSE.