The Excel NOT Function

Basic Description

The Excel NOT function receives a logical value and simply returns the opposite logical value. I.e. if supplied with the value TRUE, the Not function returns FALSE and if supplied with the value FALSE, the function returns the value TRUE.

The syntax of the function is:

NOT( logical )

where the supplied logical argument must be a logical or numeric value.

Note that any numeric values, except zero are treated as the logical value TRUE, and the value zero is treated as the logical value FALSE.


Excel Not Function Examples

The following spreadsheet shows examples of the Excel Not Function.

 Formulas:
 AB
1=NOT( TRUE ) 
2=NOT( B1=1 ) 
3=NOT( ISBLANK( B1 ) ) 
 Results:
 AB
1FALSE 
2TRUE 
3FALSE 

Note that the example in cell A3 of the above spreadsheet uses the Excel Isblank function with the Not function, to test if cell B1 is blank.


Further details and examples of the Excel Not function are provided on the Microsoft Office website.


Not Function Error

If you get an error from the Excel Not function, this is likely to be the #VALUE! error:

Common Error
#VALUE!-Occurs if the supplied argument is not a logical or numeric value.