NOT Excel Function

The NOT Excel Function is an inbuilt function under the Logical Function of the Functional Library that operates under a logical test. The function is also called Boolean logic or function. The function is used as an individual function or part of the formula and other excel functions in a cell.

• If the value is TRUE, the NOT function returns FALSE.
• If the value is FALSE, the NOT function returns TRUE.

The syntax of the NOT function is =NOT(logical).

We can calculate the NOT Function as follows:

1.     Select an empty cell for the output.
2.     Type =NOT( in the selected cell. [Alternatively, type “=N” and double-click the NOT function from the list of suggestions shown by Excel.]
3.     Enter the argument and close the brackets.
4.     Press the “Enter” key.

For example, we will calculate the logical value using the NOT Excel Function.
The steps to evaluate the values by the NOT Function are as follows:

• Step 1: Select cell A2.



• Step 2:  Next, enter the formula =NOT(A10=A1) and press the “Enter” key.



The result is “TRUE”, as shown above.

The NOT Excel Function is used as follows:

First, choose an empty cell → select the “Formulas” tab → go to the “Function Library” group → click the “Logical” option drop-down → select the “NOT” function, as shown below.