What is the NOT function in Excel?
The NOT function is one of the Logical functions of Excel.
this function changes false to true or true to false.
We can find this function in the Logical of the insert function Tab.
How to use NOT function in excel
1. Click on an empty cell (like F5 )
2. Click on the fx icon (or press shift+F3)
3. In the insert function tab you will see all functions
4. Select Logical category
5. Select NOT function
6. Then select ok
7. In the Logical section we can enter a value or expression that can be evaluated as TRUE or FALSE
8. Enter in cells values as shown below:
9. Enter in logical section A2 value, the result is TRUE
10. Enter in logical section A3 value, the result is False
11. Enter in logical section A4 value, the result is False
12. Enter in logical section A5=4 value, the result is False
13. Enter in logical section A5<5 value, the result is False
14. Enter in logical section A5>5 value, the result is TRUE
Examples of NOT function in excel
Python code for NOT function
x = True
print(not x)What is the purpose of NOT function?
What is the Return value of NOT function?
How many arguments does NOT function have?
This function has just 1 Argument.
The argument of ABS function is number.
The argument of ABS function is required and not optional.
Which version of excel supports NOT function?
This function is available for all excel versions (2003-2019)
