How to use the Not function Excel

Download PC Repair Tool to quickly observe & fix Windows errors automatically

The Non function in Microsoft Excel is a built-in Logical function, and its purpose is to reverse the logic of its argument. It ensures that one value is not equal to another. When given Truthful, NOT returns Fake. When NOT given Simulated, NOT returns TRUE. Logical values are used in spreadsheets to examination whether the situation is TRUE or False.

How do I create a NOT formula in Excel?

The formula for the NOT function is =Not(logical).

The syntax below for the NOT function is below:

Logical: A value or logical expression that can be evaluated as TRUE or False.

How to utilize the Not function Excel

Follow the steps below to use the Excel NOT function:

1. Launch Microsoft Excel
2. Create a table or use an existing table from your files
3. Place the formula into the cell you want to see the issue
4. Press the enter key to run into the result.

Launch Microsoft Excel.

Create a table or use an existing table from your files.

Type the formula into the cell you want to place the effect =Non(A2="Sherwin-Williams").

Then press the Enter key to see the result.

The result would exist the reverse, which is Imitation.

If placed into the jail cell =NOT(A2="Clare"). The NOT function will return the event equally True.

In Microsoft Excel, non only can yous use the Non function by itself, but you lot can besides utilize it with conjunctions such as IF, OR, and AND.

If you blazon into the prison cell =NOT(OR(A3="Benjamin Moore", A3="Clare")), the outcome will be Faux.

If you choose to type =NOT(OR(A2="Benjamin Moore", A3="Clare")), the result would be True.

There are two other methods to employ the Non part

Method one is to click the fx button on the top left of the Excel worksheet.

An Insert Function dialog box will announced.

Inside the dialog box in the section, Select a Category, select Logical from the list box.

In the section Select a Function, cull the Non part from the list.

So click OK.

A Part Arguments dialog box will open.

In the Logical entry box, input into the entry box cell A2="Sherwin-Williams".

So click OK.

Method two is to click the Formulas tab, click the Logical button in the Function Library group.

Then select Not from the drib-down menu.

A Function Arguments dialog box will open up.

We hope this tutorial helps you empathise how to employ the Not function in Microsoft Excel; if you have questions near the tutorial, let usa know in the comments.

Read: How to link a office of information in Excel Worksheet in Microsoft PowerPoint.

How practice you write non in Excel?

In Microsoft Excel, <> means Not equal to. The <> operator in Excel checks if 2 values are not equal to each other.

Shantel is a university student studying for Bachelor of Scientific discipline in Information Engineering science. Her goal is to become a Database Administrator or a System Administrator. She enjoys reading and watching historical documentaries and dramas.

Source: https://www.thewindowsclub.com/how-to-use-the-not-function-microsoft-excel

Posted by: newmangreste.blogspot.com

Share this post