NOT Function in Excel
Beginner
Reverses the logic of its argument - returns TRUE if argument is FALSE, FALSE if argument is TRUE.
Syntax
=NOT(logical)Example
Use Case
Flag records that are NOT marked as complete.
Common Errors to Avoid
- Only accepts single logical value, not multiple arguments
- Often unnecessary - can use opposite comparison instead (<> vs =)
- Confusing when nested deeply in complex formulas
Pro Tips
Use to reverse boolean logic: =NOT(A1='Complete') is equivalent to =A1<>'Complete'. Helpful with other logical functions: =IF(NOT(AND(A1>0,B1>0)),'Error','OK'). Keep formulas readable - sometimes opposite logic is clearer.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →