The NOT function reverses the value of its argument. Use NOT when you want to make sure a value is not equal to one particular value. 

Syntax

=NOT(logical)

Arguments

Argument Description
logical A value or expression that can be evaluated to TRUE or FALSE

Examples

  A B C D
1 Data      
2        
3 Formula Result Notes
4 =NOT(TRUE) FALSE If logical is TRUE, NOT returns FALSE
5 =NOT(FALSE) TRUE If logical is FALSE, NOT returns TRUE
6 =NOT(1+1=2) FALSE Reverses an equation that evaluates to TRUE
7 =NOT(A1=1) TRUE It is TRUE that A1 does not equal 1
8 =NOT(ISBLANK(A1)) FALSE A1 is not blank

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied argument is not a logical value