The Not function in Microsoft Excel is a built-in Logical function, and its goal is to reverse the logic of its argument. It ensures that one worth shouldn’t be equal to one other. When given TRUE, NOT returns FALSE. When NOT given FALSE, NOT returns TRUE. Logical values are utilized in spreadsheets to take a look at whether or not the state of affairs is TRUE or False.
How do I create a NOT system in Excel?
The system for the NOT function is =Not(logical).
The syntax under for the NOT function is under:
Logical: A worth or logical expression that may be evaluated as TRUE or False.
How to use the Not function Excel
Comply with the steps under to use the Excel NOT function:
- Launch Microsoft Excel
- Create a desk or use an present desk out of your recordsdata
- Place the system into the cell you need to see the end result
- Press the enter key to see the end result.
Launch Microsoft Excel.
Create a desk or use an present desk out of your recordsdata.
Sort the system into the cell you need to place the end result =NOT(A2=”Sherwin-Williams”).
Then press the Enter key to see the end result.
The end result can be the reverse, which is FALSE.
If positioned into the cell =NOT(A2=”Clare”). The NOT function will return the end result as TRUE.
In Microsoft Excel, not solely are you able to use the NOT function by itself, however you may also use it with conjunctions resembling IF, OR, and AND.
In the event you kind into the cell =NOT(OR(A3=”Benjamin Moore”, A3=”Clare”)), the end result will likely be FALSE.
In the event you select to kind =NOT(OR(A2=”Benjamin Moore”, A3=”Clare”)), the end result can be TRUE.
There are two different strategies to use the NOT function
Technique one is to click on the fx button on the prime left of the Excel worksheet.
An Insert Function dialog field will seem.
Inside the dialog field in the part, Choose a Class, choose Logical from the checklist field.
In the part Choose a Function, select the NOT function from the checklist.
Then click on OK.
A Function Arguments dialog field will open.
In the Logical entry field, enter into the entry field cell A2=”Sherwin-Williams”.
Then click on OK.
Technique two is to click on the Formulation tab, click on the Logical button in the Function Library group.
Then choose NOT from the drop-down menu.
A Function Arguments dialog field will open.
We hope this tutorial helps you perceive how to use the NOT function in Microsoft Excel; in case you have questions on the tutorial, tell us in the feedback.
Learn: How to hyperlink part of knowledge in Excel Worksheet in Microsoft PowerPoint.
