NOT

Beginner

Logical

Reverses the logic of its argument. Returns TRUE if argument is FALSE, and FALSE if argument is TRUE.

Syntax
=NOT(logical)
Parameters
logical
Required
(logical)

Value or expression to reverse

Examples
Real-world examples to help you understand how to use NOT

Reverse logical value

=NOT(A1>10)

TRUE if A1 is NOT greater than 10

Result: TRUE or FALSE

Exclude items

=NOT(A1="Exclude")

TRUE if A1 does not equal "Exclude"

Result: TRUE or FALSE

Combined with other functions

=IF(NOT(ISBLANK(A1)), "Has value", "Empty")

Checks if cell is not blank

Result: Text result

Common Use Cases
  • ✓Exclude specific values
  • ✓Reverse conditions
  • ✓Negative validation
  • ✓Exception logic
  • ✓Filter inversions
Pro Tips
  • 💡Reverses TRUE to FALSE and vice versa
  • 💡Useful for negative conditions
  • 💡Combine with AND/OR for complex logic
  • 💡Can make formulas more readable
Common Errors
  • ⚠️Double negatives creating confusion
  • ⚠️Using NOT when simpler operators work
  • ⚠️Forgetting parentheses
Related Formulas
ANDORIFISBLANK

Need a Custom NOT Formula?

Our AI can generate tailored formulas based on your specific needs

Generate Custom Formula