# NOT Excel Formula

In this tutorial, you will learn about NOT excel formula. NOT function excel is useful to reverse a logic value of TRUE to FALSE and vice versa.

## Why do We Need to Learn NOT Function Excel?

In doing data processing on a spreadsheet, especially when using a function with a criteria evaluation process in it, sometimes we need to use a logic value reverse process. This sometimes becomes a need for us because we want an evaluation result with the basis of the criteria exception or maybe we want to get the reverse result of a formula that uses a process with a logic values basis in it.

This need is often found when we evaluate criteria by utilizing various formulas with the prefix of IS in the spreadsheet. As an example, imagine if we want to mark all cells with non-number content in a column with a particular color using the Conditional Formatting feature. If we see the IS formulas which are available in the spreadsheet for that purpose, then we only find ISNUMBER which is relevant to use. The problem is the result of ISNUMBER is the opposite of our need. If we do not use a formula to help us and do it manually, then it will be very troublesome if there are much data to be processed by using the evaluation process that produces the logic values.

To make it easier for you to reverse a logic condition just like the need above, then you can use NOT excel formula. NOT function excel can help you to turn TRUE into FALSE and vice versa. It is very useful to be understood if you often use criteria evaluation processes in your spreadsheet data processing.

## What is NOT Excel Formula?

NOT excel formula is a formula with the usage objective to get the reverse result of a logic value that we have, which means it turns TRUE into FALSE and FALSE into TRUE. NOT function excel is often used to help the evaluation process in the IF formula.

Generally, the input of this function can be explained briefly as follows:

=NOT(logical)

Note:
logical = logic value or the process that produces logic value that you want to be reversed

## How to Use NOT Function Excel?

The following will explain the steps to write NOT excel formula. NOT function excel is easy to use because it only needs the input of logic value that you want to process.

## Using NOT Excel Formula

1. Type equal sign ( = ) in the cell where you want to put the result in 2. Type NOT (can be with large and small letters) and open bracket sign after = 3. Input the logic value or the process that produces the logic value / cell coordinate where it is located after open bracket sign 4. Type close bracket sign 5. Press Enter
6. The process is done! ## Exercise

After you have learned how to write NOT function excel, now is the time for you to do an exercise to deepen your understanding.

### Instructions

Use NOT in doing all the instructions below:
1. Mark the data in the most left column with “Not Number” and “Number” in the column no 1! Use IF and ISNUMBER formulas to help you do it!
2. Mark the data in the most left column with “Not Text” and “Text” in the column no 2! Use IF and ISTEXT formulas to help you do it!
3. Mark the data in the most left column with “Not Error” and “Error” in the column no 3! Use IF and ISERROR formulas to help you do it!

If your need is to give the final logic value result to more than one criteria-based evaluation process results, then you can use AND formula or OR to help you.