How To Use Excel NOT Function?

Ads

Listen to this article.

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:

https://www.microsoft.com/en-in/microsoft-365/excel

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.

Syntax

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.

=NOT(logical)

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.

Let’s reverse these values using the NOT function. For that, we will need to apply the above-mentioned 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.

Closure

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 Aawexcel.com.

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