How to use NOT function

This post will teach you how the NOT function works and what it is used for. With the NOT function, one of the logical functions, you can reach the conclusion that one value is different to another.

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.

Example of the NOT function in practice

Examples of the NOT function to reverse arguments.  E.G. =NOT(1+1=2)o

Technical Details

General Examples of using the NOT function by itself, and in combination with IF, AND and OR

Here are some non-specific examples of how the NOT function works alone, and alongside IFAND and OR.

Examples of NOT with IF, AND and OR functions
=NOT(A2>100)A2 is NOT greater than 100.
=IF(AND(NOT(A2>1),NOT(A2<100)),A2,”The value is out of range”)50 is greater than 1 (TRUE), AND 50 is less than 100 (TRUE), so NOT reverses both arguments to FALSE. AND needs both arguments to be TRUE, so it brings back the result if FALSE.
=IF(OR(NOT(A3<0),NOT(A3>50)),A3,”The value is out of range”)100 is not less than 0 (FALSE), and 100 is greater than 50 (TRUE), so NOT reverses the arguments to TRUE/FALSE. OR simply mandates one argument to be TRUE, so it returns the result if TRUE.

Sales Commission Calculation

Here is a fairly regular situation where we must calculate if sales people qualify for a bonus using NOT with IF and AND.

Example of calculating a sales bonus with IF, AND, and NOT.  Formula in cell E14 is =IF(AND(NOT(B14<$B$7),NOT(C14<$B$5)),B14*$B$8,0)
  • =IF(AND(NOT(B14<$B$7),NOT(C14<$B$5)),B14*$B$8,0)– IF Total Sales is NOT less than Sales Goal, AND Accounts are NOT less than the Account Goal, then multiply Total Sales by the Commission %, otherwise return 0.

Need more help?

You can use any of the following resources to aid you with how the NOT function works and/or recommend a innovative tool or development to Excel:

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

Related Topics

Video: Advanced IF functions
Learn how to use nested functions in a formula
IF function
AND function
OR function
Overview of formulas in Excel
How to avoid broken formulas
Use error checking to detect errors in formulas
Keyboard shortcuts in Excel
Logical functions (reference)
Excel functions (alphabetical)
Excel functions (by category)

Leave a Reply

%d bloggers like this: