NOT function in Excel

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 )

empty cell excel

2. Click on the fx icon (or press shift+F3)

 Click on the fx icon (or press shift+F3)

3. In the insert function tab you will see all functions

insert function tab excel

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:

How to use NOT function in excel

9. Enter in logical section A2 value, the result is TRUE

NOT function in excel

10. Enter in logical section A3 value, the result is False

How to use NOT function in excel

11. Enter in logical section A4 value, the result is False

example of NOT function in excel

12. Enter in logical section A5=4 value, the result is False

no function excel

13. Enter in logical section A5<5 value, the result is False

what is not function excel

14. Enter in logical section A5>5 value, the result is TRUE

not function example

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)

Errors in NOT function

NOT related functions

Leave a Reply

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