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

    NOT Excel Formula - Screenshot of Step 1

  2. Type NOT (can be with large and small letters) and open bracket sign after =

    NOT Excel Formula - Screenshot of Step 2

  3. Input the logic value or the process that produces the logic value / cell coordinate where it is located after open bracket sign

    NOT Excel Formula - Screenshot of Step 3

  4. Type close bracket sign

    NOT Excel Formula - Screenshot of Step 4

  5. Press Enter
  6. The process is done!

    NOT Excel Formula - Screenshot of Step 6



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.

Download the exercise file below and work on all of the instructions. Download the answer key file if you are confused about how to do the exercise instructions or if you have already done the exercise and want to check your answers.

Link of the exercise file:
Download here

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!

Link of the answer key file:
Download here


Additional Note


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.



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on




Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert