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
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 IF, AND and OR.
|=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.
- =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:
Video: Advanced IF functions
Learn how to use nested functions in a formula
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)