Beginner
Logical
NOT
Reverses a TRUE/FALSE value — turns TRUE into FALSE, and FALSE into TRUE.
Compatibility: All Excel versions
Syntax
=NOT(logical)
Example
=NOT(A1="Complete")
When to Use It
Use NOT to flip a condition around, e.g. flagging every row that is NOT marked "Complete" instead of writing a separate condition for every other possible status.