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

Lookup and Reference Examples

  • How to use Excel INDIRECT Function
  • Lookup entire row in Excel
  • How to get address of named range in Excel
  • How to use Excel MATCH Function
  • Excel Advanced Lookup using Index and Match Functions

Data Analysis Examples

  • How to create dynamic reference table name in Excel
  • How To Filter Data in Excel
  • How to create a Histogram in Excel
  • Everything about Charts in Excel
  • Get column index in Excel Table

Data Validation Examples

  • How To Create Drop-down List in Excel
  • Excel Data validation must not contain
  • Excel Data validation whole percentage only
  • Excel Data validation require unique number
  • Excel Data validation specific characters only

NOT function: Description, Usage, Syntax, Examples and Explanation

by

What is NOT function in Excel?

NOT function is one of the Logical functions in Microsoft Excel that is used when you want to make sure one value is not equal to another.

Worked Example:   If NOT this or that in Excel

Examples of NOT function

Examples

Here are some general examples of using NOT by itself, and in conjunction with IF, AND and OR.

Formula Description
=NOT(A2>100) A2 is NOT greater than 100
=IF(AND(NOT(A2>1),NOT(A2<100)),A2,”The value is out of range”) 50 is greater than 1 (TRUE), AND 50 is less than 100 (TRUE), so NOT reverses both arguments to FALSE. ANDrequires both arguments to be TRUE, so it returns the result if FALSE.
=IF(OR(NOT(A3<0),NOT(A3>50)),A3,”The value is out of range”) 100 is not less than 0 (FALSE), and 100 is greater than 50 (TRUE), so NOT reverses the arguments to TRUE/FALSE. ORonly requires one argument to be TRUE, so it returns the result if TRUE.
Worked Example:   If cell is not blank in Excel
Worked Example:   Count cells that contain numbers in Excel

Post navigation

Previous Post:

SWITCH function: Description, Usage, Syntax, Examples and Explanation

Next Post:

AND function: Description, Usage, Syntax, Examples and Explanation

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
  • FIXED function: Description, Usage, Syntax, Examples and Explanation
  • ASC function: Description, Usage, Syntax, Examples and Explanation
  • How to check if cell contains one of many things in Excel
  • Count Number of Words in Excel
  • T function: Description, Usage, Syntax, Examples and Explanation
  • Get first day of previous month in Excel
  • Add days to date in Excel
  • How to calculate most recent day of week in Excel
  • How to determine year is a leap year in Excel
  • How to get Weekdays, Working days between Two Dates in Excel
  • CUMPRINC function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate Net Present Value (NPV) in Excel
  • DURATION function: Description, Usage, Syntax, Examples and Explanation
  • Calculate cumulative loan interest in Excel
  • ACCRINT function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles