What are Excel formulas? Learn how to write and use Excel formulas effectively

The NOT function in Excel is certainly familiar to office workers, students, and students when using Excel. This is one of the functions that cannot be missed when working with Excel, helping users optimize their work and save time in processing.

What does NOT mean in Excel? How is it written?

In written language, NOT is used to compare similar and dissimilar phenomena and objects. In data, numbers, NOT represents that they are not equal.

NOT is written and symbolized as: ≠. However, in Excel, the way to write NOT will be different when users use the comparison function with NOT, Excel will be represented by less than and greater than: <>, if users use NOT in Excel, they will receive the result returned as: TRUE/FALSE.

• Symbol in mathematical formulas: ≠
• Symbol in Excel function: <>

How to use NOT in Excel

In Excel, NOT is used to type text, create mathematical formulas or create comparison functions in Excel.

Used to type text, create mathematical formulas

Users want to perform comparison calculations in Excel, they must first have a data table. Then open Excel and follow the instructions below:

Step 1: In Excel, click the cursor in the cell to insert the symbol, then select Insert.

Step 2: Select the Symbols tab on the toolbar and click Symbols to insert the NOT character into the cell in Excel.

Step 3: In the Symbols dialog box, select the Symbols tab, and then proceed to select the NOT character: ≠.

Step 4: Once you have found the symbol ≠, continue to select Insert to insert the symbol into the cell in Excel.

Tip: It is really difficult and time-consuming to find the symbol ≠ in Excel because the symbol table has many different small symbols. So you can find ≠ on Google or in this article and copy it to insert into your Excel file so you can use it.

Using NOT in Excel through a specific example

You can also use the NOT function in Excel to compare the values in the columns. As in the example below, we will compare the values in columns A and B and return the result “Different and Similar”.

Step 1: In cell E3, use the IF function combined with NOT to perform the comparison: =IF(A3<>B3;”Different”;”Similar”).

Step 2: If you only need to receive results automatically with the TRUE, FALSE function, enter the into the cell as follows: =A3<>B3. You will receive the results of each correct or wrong.

Note: The <> is used only in Excel functions and formulas to compare two values or two cell addresses that contain values or two formulas that need to be compared.

Conclusion

This article was done on a desktop computer running Windows operating system, using Excel 2016 version. Users can perform similar operations with other versions of Excel such as Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2019, and macOS.

You may also like

Learn the functions and usage of the MID function in Excel with the most detailed examples

Excel’s MID function is incredibly easy to use, and if you know how to use it correctly, it can save you a lot of time in your work and studies. To help you better understand the MID function, FPT Shop will explain its usage along with detailed examples in the following article.

What is the TRUNC function in Excel? How to use the TRUNC function to round numbers to integer in a super easy way

In this article, we will delve into the details of the TRUNC function in Excel, an important tool in dealing with numerical data. We will explore how this function removes the decimal part, retains the integer part, and how it can be seamlessly integrated into the spreadsheet workflow.

15 Must-Know Excel Tricks for Accountants and Office Professionals

Excel is a widely used software tool among office workers. However, not everyone knows how to maximize their productivity while minimizing their working time. In this article, FPT Shop will reveal some incredibly useful Excel tricks to help you achieve that.