The Excel NOT Function

Function Description

The Excel NOT function returns the opposite to a supplied logical value.

I.e.

If supplied with the value TRUE, the Not function returns FALSE;
If supplied with the value FALSE, the Not function returns TRUE.

The syntax of the Not function is:

NOT( logical )

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

Note that, if the supplied logical argument is a numeric value, zero is treated as the logical value FALSE and any other numeric value is treated as the logical value TRUE.

Excel Not Function Examples

The following spreadsheet shows examples of the Excel Not Function.

Formulas:

	A	B
1	=NOT( TRUE )
2	=NOT( B1=1 )
3	=NOT( ISBLANK( B1 ) )

Results:

	A	B
1	FALSE
2	TRUE
3	FALSE

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.

For further details and examples of the Excel Not function, see 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.

Return to the Excel Logical Functions Page
Return to the List of All Built-In Excel Functions