# NOT Function - Change False to True and True to False in Excel

Author: | Edits: don

Change True to False and False to True with this simple function in Excel.

To do this, we use the NOT function.

## Syntax

``=NOT(logical)``

Argument Description

Logical

The value that should have its result reversed. Input TRUE and it becomes FALSE and FALSE and it becomes TRUE. You can put a cell reference, an actual value, or a logical function in for this argument.

## Example

The NOT function is a logical function in Excel that simply changes the output of other logical functions.

Remember that a logical function is any function that evaluates to either True or False.

For this example, I will use a basic list of values in order to make things simple.

Let's say that we want to have a list of data where each cell in a row evaluates to False; if each row is False, then we are happy and want to output a positive result "True" in another cell.

Here is our sample data:

The highlighted row is the only one that we want to recognize and we want to do this by outputting TRUE in column C row 3.

The first step is to create an OR function that checks column A and B. This function will check if the value in column A OR column B is True.

Copy the function down and we get this:

3 True values and one False value.

In this case, we simply want to reverse the result so that we get only a True value when there is a False in both column A and B.

To do this, surround the OR function with the NOT function:

Copy the formula down and we get the desired result:

## Notes

The NOT function is simple and, at first, it seems rather useless. However, I can assure you that when you work with more complex logical statements, or even the simple example in this tutorial, the NOT function is a life-saver. Just keep this function in the back of your mind so you can use it when needed.

Excel Function: NOT()

#### Question? Ask it in our Excel Forum

##### Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

Tutorial Details
Excel Function: NOT()