Skip to content

How To Use Excel NOT Function?

Listen to this article.
NOT FunctionPin
NOT Function

Excel NOT Function: We all know that Excel is a powerful spreadsheet tool that helps to perform various mathematical operations. It provides a huge number of built-in formulas and functions for calculations. On that note, Excel provides a NOT function to convert the zero’s to one’s and the logical expression TRUE as FALSE, and vice versa.

If you want to use this function on your Excel spreadsheet, then keep reading this blog post. Here, we will understand the steps to use Excel NOT Function with proper explanation, syntax, and examples. Get the official version of MS Excel from the following link:

Excel NOT FunctionPin
Excel NOT Function

Usage of NOT Function

  • The NOT function in Excel will reverse a given logical (TRUE, FALSE) or Boolean value (0, 1) on your spreadsheet. It is one of the built-in functions in Excel.
  • When the given value is TRUE, NOT Function returns FALSE or vice versa.
  • Similarly, when we give 0 as input, the NOT function will return 1, or vice versa.


  • Here, you will see the syntax of the NOT function.
  • To apply this NOT function on your spreadsheet, you have to select a cell and enter the formula in the following format.
  • Once you enter the formula, just click on the Enter button to get the result.


Argument Description

  • logical – A given value that can be evaluated as TRUE or FALSE.

Practical Examples

Here, let’s see some examples of NOT function and analyze how it works in Microsoft Excel.

  • Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
  • For example, we entered the Boolean values 0 and 1 in respected cells B3 & B4. And, we all know that in Boolean expressions, 0 refers to FALSE, and 1 refers to TRUE.
Input Boolean ValuesPin
Input Boolean Values
  • Let’s reverse these values using the NOT function. For that, we will need to apply the above-mentioned formula.
Apply the formulaPin
Apply the formula
  • Once you have entered the formula, you need to click on the Enter button to get the reversed values, as shown below.
  • Let’s see one more example to make it easy for you. Here, we will give some conditions to check if it is true or false.
  • The NOT function will convert TRUE as FALSE or vice versa.
  • In the below-given screenshot, you can see input values in the range B3:C5. And now, we will check the following conditions.
    • Check if cell C3 has the value “red.” (This statement is TRUE, so it returns the value FALSE using the NOT function).
    • Then check if cell B4 is equal to “ball.” (It is a FALSE statement, so it returns the value TRUE).
    • Check if cell C5 has the value “paper.” (This statement is a FALSE statement, so it returns the value TRUE).
  • Now, you have to apply the NOT function to get the reversed logical expressions on the worksheet.


Let’s wrap up this blog post by knowing the usage of NOT Function in Excel using syntax and proper examples. If you found this article helpful, then leave a comment in the below section. If you want to learn more about Excel functions, then visit our webpage

Video Tutorial

You can refer to the below-given video to know how to apply the NOT function on your worksheet and how it reverses the given values (Boolean and logical).

Read Ahead:


Leave a Reply

Your email address will not be published. Required fields are marked *

Share to...