Excel NOT function
In Excel, the NOT function helps users to check if one value is not equal to another. It returns the opposite of a given logical or boolean value. If we give TRUE, it will return FALSE and when given FALSE, it will return TRUE. So, it will return a reverse logical value.
The syntax for the NOT function in Excel is:
Returns a reversed logical value.
For example, there is a list of fruits, you may want to exclude Banana that you don’t like. So, the NOT function can do you a favor, and then you will find all Banana cells returned FALSE, otherwise, TURE is returned.
1. If you want to test several conditions in a single formula, you can use NOT with the AND or OR function. For example, if you want to exclude Banana and Apple, the formula would like this:
2. And if want to exclude the Bananas which are from South, you should use NOT in combination with the Excel AND function:
It is another common usage of the NOT function, you can combine NOT and ISBLANK functions to deal with some blank cells when applying a formula.
For example, I have a report with employee’s sales, and some person overfulfill the task. If they have extra sales, they will get some bonus, which equals extra sales *10%. If their extra sales are blanks, no bonus.
You can use this formula which combines the NOT and ISBLANK functions together, and then you will get the following result: