Close the Skill Gap -> Enroll to be a Certified Financial Modeling & Valuation Analyst (FMVA)® Today!

NOT Function

Checks if one value is not equal to another

What is the NOT Function?

The NOT function is a Logical function. The function helps check if one value is not equal to another. If we give TRUE, it will return FALSE and when given FALSE, it will return TRUE. So, basically, it will return a reverse logical value.

As a financial analyst, the NOT function is useful when we wish to know when a specific condition was not met.

 

Formula

=NOT(logical)

 

Where:

  1. Logical (required argument) – The argument should be a logical or numerical value. If the given logical argument is a numeric value, zero is treated as the logical value FALSE and any other numeric value is treated as the logical value TRUE.

 

How to use the NOT Function in Excel?

NOT is a built-in function that can be used as a worksheet function in Excel. To understand the uses of this function, let us consider a few examples:

 

Example 1

Suppose we don’t want the red and blue combination for soft toys. We are given the data below:

 

NOT Function

 

To avoid the Red Blue combination, we will use the formula =NOT(C6=”Red Blue”).

 

NOT Function - Example 1

 

We will get the results below:

 

NOT Function - Example 1a

 

If we wish to test several conditions in a single formula, then we can use NOT in conjunction with the AND or OR function. For example, if we wanted to exclude Red Blue and slate black, the formula would be =NOT(OR(C2=”Slate black”, C2=”Red Blue”).

 

Example 2

Suppose we need to put no increase for employees. Basically, we wish to reverse the behavior of some other functions. For instance, we can combine NOT and ISBLANK functions to create the ISNOTBLANK formula.

The data given to us are shown below:

 

NOT Function - Example 2

 

The formula to be used would be =IF(NOT(ISBLANK(C5)), C5*0.25, “No bonus”), as shown below:

 

NOT Function - Example 2a

 

The formula tells Excel to do the following:

  • If the cell C5 is not empty, multiply the extra sales in C5 by 0.25, which gives the 25% bonus to each salesman who has made any extra sales.
  • If there are no extra sales that is C5 is blank, then the text “No bonus” appears.

We will get the results below:

 

NOT Function - Example 2b

 

In essence, this is how we use Logical functions in Excel. We can use it with AND, XOR, OR and NOT.

 

Example 3

Let’s say we wish to highlight a cell that doesn’t meet specific criteria. In such scenario, we can use NOT with IF and OR function. Suppose we received an order to manufacture soft toys of Red and Blue color. The colors are specified by the client and we can’t change them.

We are given the inventory below:

 

NOT Function - Example 3

 

Using the formula =IF(NOT(OR(B5=”red”,B5=”blue”)),”x”,””), we can highlight toys with the two colors:

 

NOT Function - Example 3a

 

We will get the following result:

 

NOT Function - Example 3b

 

Here, we marked inventory that was not of specific colors, that is, which were not Red or Blue.

Using NOT and OR, we will get TRUE if the specified cell is not Red or Blue.

We added an empty string “”  so if the result is FALSE, we get X and nothing if TRUE. We can expand OR to add additional conditions if required.

 

Things to remember about the NOT function

  1. #VALUE! error – Occurs when the given argument is not a logical value or numeric value.

 

Click here to download the sample Excel file

 

Additional resources

Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:

  • Excel Functions for Finance
  • Advanced Excel Formulas Course
  • Advanced Excel Formulas You Must Know
  • Excel Shortcuts for PC and Mac

Free Excel Tutorial

To master the art of Excel, check out CFI’s FREE Excel Crash Course, which teaches you how to become an Excel power user.  Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.

 

Launch CFI’s Free Excel Course now to take your career to the next level and move up the ladder!