# 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.

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.

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:

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.