How to Use the NOT Function in Excel: A Practical Guide

Formulas & functions · Updated November 18, 2026

To reverse a logical value in Excel, use the NOT function: with TRUE in A2, enter =NOT(A2) in another cell to return FALSE. NOT turns TRUE into FALSE and FALSE into TRUE, which is useful when you need to check whether a condition is not met.

You can use NOT on a cell value, a comparison, or another function that returns TRUE or FALSE. The guide below uses Microsoft Excel for Microsoft 365 on Windows; the NOT function works the same way in Excel for Mac and Excel for the web. The examples use commas between formula arguments. If your regional settings require semicolons, replace the commas in formulas that have multiple arguments.

What You’ll Need

  • A workbook in Excel for Microsoft 365, Excel for Mac, or Excel for the web.
  • A cell containing a value or condition to test. You can also type a condition directly into the formula.
  • A blank cell for the formula result. If you plan to copy a formula down a list, make sure the rows use a consistent layout.

Step-by-Step

  1. Identify what you want to reverse. NOT does not search for a word or change a cell’s contents. It changes a logical result: TRUE becomes FALSE, and FALSE becomes TRUE. For example, if a check says that an order is complete, NOT can tell you whether it is not complete. Decide what result you want to test before writing the formula. This helps you avoid reversing the wrong condition.
  2. Enter a simple NOT formula. Suppose A2 contains the logical value TRUE. In B2, type =NOT(A2) and press Enter. B2 displays FALSE. If A2 contains FALSE instead, the same formula returns TRUE. The argument inside the parentheses is the value or condition you want Excel to reverse. You can type the formula in the formula bar or directly into the selected cell.
  3. Use NOT with a comparison. Comparisons such as equals, greater than, and less than produce TRUE or FALSE, so they can go inside NOT. Suppose A2 contains an order status. To check whether that status is anything other than Complete, enter =NOT(A2="Complete") in B2. With A2 set to Pending, the comparison is FALSE and the formula returns TRUE. With A2 set to Complete, it returns FALSE. Excel’s text comparison is generally not case-sensitive, so complete also matches Complete.
  4. Reverse a numeric test. Suppose B2 contains a score, and your original test is whether it is at least 100. With the score in B2, enter =NOT(B2>=100) in C2. If B2 is 75, the test B2 greater than or equal to 100 is FALSE, so NOT returns TRUE. If B2 is 120, NOT returns FALSE. This formula answers “Is the score not at least 100?” In ordinary numeric cases, that is equivalent to asking whether the score is below 100.
  5. Return a useful message with IF. NOT often becomes more readable when paired with IF, which displays one result when a test is TRUE and another when it is FALSE. Suppose D2 contains a payment status. With the status in D2, enter =IF(NOT(D2="Paid"),"Follow up","No action") in E2. If D2 contains Overdue, the formula returns Follow up. If D2 contains Paid, it returns No action. Replace the labels with messages that suit your own worksheet.
  6. Combine NOT with another condition. You can use NOT as part of a larger test. Suppose C2 contains a customer name and B2 contains an order total. With the name in C2 and the total in B2, enter =AND(NOT(C2=""),B2>=100) in D2. This returns TRUE only when C2 is not empty and B2 is at least 100. If C2 is blank, or if the total is less than 100, the result is FALSE. The empty quotation marks represent an empty text value.
  7. Copy the formula to other rows and check the results. Select the cell containing your formula, then drag its fill handle (the small square at the lower-right corner of the selected cell) down the column. Excel adjusts relative references for each row, so a formula based on A2 will refer to A3 on the next row. Check a few rows against their source values, including one that should return TRUE and one that should return FALSE. If the same fixed cell must be tested in every row, use an absolute reference such as $A$2 in the formula.

Common Mistakes

Reversing the wrong part of a test: NOT applies to the whole value or expression inside its parentheses. A formula that reverses a comparison can have a different meaning from one that reverses a combined condition. For instance, NOT applied to an AND result reverses whether both conditions are true; it does not separately reverse each condition. Add parentheses deliberately and read the complete test aloud.

Expecting NOT to return a custom word: NOT returns a logical value, TRUE or FALSE. It does not produce messages such as “No” or “Needs review.” Use IF around NOT when you need a label, as in the payment example above.

Comparing against the wrong text: A trailing space, spelling difference, or unexpected value can make a comparison return FALSE. A status that looks like Complete might contain a space after the word. Check the source cell, and consider using Excel’s TRIM function to remove ordinary leading and trailing spaces if that is appropriate for your data.

Using the formula to test for a blank without considering the data: NOT applied to a comparison with an empty string can be helpful, but it is not always the same as testing every possible kind of empty-looking cell. A cell containing a formula that returns an empty string is not technically blank, even though it appears empty. Choose a test that matches how the data was created.

Forgetting that a result of FALSE can be correct: If your condition is already true, NOT should return FALSE. That is the expected result, not an error. Check the original condition first, then confirm that reversing it is what you intended.

Tips

  • Use NOT when the positive condition is easy to express but you need its opposite. For a simple test, Excel’s not-equal operator, written as <>, may be shorter; NOT can make a more complex condition easier to follow.
  • Give columns descriptive headings such as “Needs follow-up?” so that TRUE and FALSE results are easier to interpret.
  • Use parentheses to make nested tests easier to scan. Even when Excel can infer the calculation order, clear grouping helps you and other workbook users review the logic.
  • Test boundary values. If a rule uses at least 100, try 99, 100, and 101 to verify that the threshold behaves as expected.
  • Keep the condition and the returned message conceptually separate. NOT decides whether a test is reversed; IF decides what text or value to show for each outcome.
  • If you need to check for several different conditions, consider whether AND or OR better describes the rule. NOT can reverse the overall result of either function, but the resulting logic may be less clear than writing the intended rule directly.

Troubleshooting

The cell shows #VALUE!: Check whether the argument is a value Excel can interpret as logical or numeric. NOT is designed to reverse TRUE or FALSE results. Text that looks like a logical value but is stored as ordinary text may not behave like the actual logical value. Verify the source cell, and try using a comparison that explicitly tests its contents.

The formula is displayed instead of a result: Confirm that the cell is not formatted as Text. Change the format to General from Home > Number Format, then edit the cell and press Enter so Excel evaluates the formula. Also check that the formula begins with an equals sign and that Show Formulas is not turned on. In Windows, Ctrl+` toggles Show Formulas; on a Mac, the shortcut can vary by keyboard layout, so use the Formulas tab’s Show Formulas control if needed.

The answer is the opposite of what you expected: Write down the original condition in plain language and test it separately. For example, ask whether the comparison itself should be TRUE for the value in the row. Then apply NOT mentally: TRUE becomes FALSE; FALSE becomes TRUE. This simple check often reveals whether the comparison or the reversal is wrong.

Every copied row gives the same answer: Inspect the cell references in a copied formula. An accidental absolute reference such as $A$2 will keep pointing to one cell. If each row should use its own value, remove the dollar signs from that reference. Conversely, if one fixed threshold cell should be used throughout, lock that reference so it does not shift as you copy.

The result changes when a cell looks empty: Check whether the cell is truly blank, contains a formula that returns an empty string, or contains spaces. Those cases can behave differently in comparisons. Select the cell and inspect the formula bar, or use a suitable test such as ISBLANK when you specifically need to test whether a cell is genuinely empty.

Excel rejects commas in a formula: Some regional settings use semicolons rather than commas as argument separators. If a formula contains multiple arguments and Excel reports a syntax problem, replace the separators with semicolons for your installation. Do not change the comparison operators or the quotation marks around text.

Frequently Asked Questions

What does the NOT function do in Excel?
It reverses a logical result. TRUE becomes FALSE, and FALSE becomes TRUE. It can reverse a direct logical value, a comparison, or another function’s logical result.

What is the syntax for NOT?
NOT takes one argument: the logical value or condition to reverse. Put that argument inside parentheses. For example, a cell reference can be the argument, or you can put a comparison there.

Can I use NOT with text or numbers?
You can use it with comparisons involving text or numbers, such as checking whether a status is not a particular word or a total is not above a threshold. For best results, make the argument a clear logical test instead of relying on Excel to interpret arbitrary text.

How do I show “No” instead of FALSE?
Wrap NOT in IF and provide the text you want for each outcome. IF can return one message when the NOT result is TRUE and another when it is FALSE. Put text results in straight double quotation marks in the formula.

Is NOT available in Excel for Mac and Excel for the web?
Yes. NOT is a standard Excel function and works in Microsoft 365 for Windows, Excel for Mac, and Excel for the web. The formula logic is the same, though separators can depend on regional settings.

Can I use NOT with AND or OR?
Yes. NOT can reverse the TRUE or FALSE result produced by AND or OR. Make sure the parentheses group the conditions you mean to test, and verify the result with examples that cover both outcomes.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.