Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel MATCH Function
  • Multi-criteria lookup and transpose in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • How to use Excel VLOOKUP Function

Data Analysis Examples

  • Reverse List in Excel
  • Use Data Form to input, edit and delete records in Excel
  • Number and Text Filters Examples in Excel
  • How to perform a t-Test in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel

Data Validation Examples

  • Excel Data validation only dates between
  • Data validation must not exist in list
  • Excel Data validation with conditional list
  • Excel Data validation allow weekday only
  • Excel Data validation whole percentage only

How to use Excel NOT Function

by

This Excel tutorial explains how to use the NOT function with syntax and examples.

Excel NOT Function Description

The Excel NOT function returns the opposite to a supplied logical value.

That is,

  • If supplied with the value TRUE, the Not function returns FALSE;
  • If supplied with the value FALSE, the Not function returns TRUE.
Worked Example:   Count cells that do not contain errors in Excel

Excel Not Function Examples

The following spreadsheet shows examples of the Excel Not Function.

Explanation: Firstly, recall that NOT function returns the opposite to a supplied logical value

Cell A3 in the example above uses Excel Isblank function with the Not function, to test if cell B1 is blank.

Worked Example:   IF, AND, OR and NOT Functions Examples in Excel

Syntax

The syntax for the NOT function in Microsoft Excel is:

NOT( logical_value )

Arguments

logical_value
An expression that either evaluates to TRUE or FALSE. If used with an expression of TRUE, then FALSE is returned. If used with an expression of FALSE, then TRUE is returned.

Returns

If the logical_value is TRUE, then the NOT function will return FALSE.
If the logical_value is FALSE, then the NOT function will return TRUE.

Worked Example:   Get first non-blank value in a list in Excel

Note that, if the supplied logical argument is a numeric value, zero is treated as the logical value FALSE and any other numeric value is treated as the logical value TRUE.

 

Post navigation

Previous Post:

How to use Excel VLOOKUP Function

Next Post:

How to use Excel AND Function

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Remove line breaks in a cell in Excel
  • How to strip non-numeric characters in Excel
  • Remove file extension from filename in Excel
  • SUBSTITUTE function: Description, Usage, Syntax, Examples and Explanation
  • How to check cell contains which things in Excel
  • List holidays between two dates in Excel
  • Get week number from date in Excel
  • How to calculate quarter from date in Excel
  • Convert Excel time to decimal minutes
  • Convert text to date in Excel
  • ODDLPRICE function: Description, Usage, Syntax, Examples and Explanation
  • ODDFYIELD function: Description, Usage, Syntax, Examples and Explanation
  • INTRATE function: Description, Usage, Syntax, Examples and Explanation
  • SYD function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate annuity for interest rate in excel
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles