Home » Excel-Built-In-Functions » Excel-Logical-Functions » 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 will return the value TRUE.

The format of the function is:

where the supplied logical argument can be supplied as a direct value, a value returned from another function, or as a reference to a cell containing a logical 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.

Examples

The following spreadsheet shows examples of use of the Excel Not Function. The spreadsheet on the left shows the format of the functions and the spreadsheet on the right shows the results.

Further information and examples of the Excel Not Function can be found on the Microsoft Office website.

Trouble Shooting

If you received an error from the Excel Not Function, this is most likely to be the #VALUE! error, which occurs if the logical argument, supplied to the function, is not a logical value and is non-numeric.

Any error suppplied to the Not Function will result in the same error message being returned from the function.