- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Advanced Excel Logical - NOT Function
Description
The NOT function reverses the value of its argument. Use NOT when you want to make sure a value is not equal to one particular value.
Syntax
NOT (logical)
Arguments
| Argument | Description | Required/ Optional |
|---|---|---|
| logical | A value or expression that can be evaluated to TRUE or FALSE. | Required |
Notes
If logical is FALSE, NOT returns TRUE.
If logical is TRUE, NOT returns FALSE.
If the argument is not a logical or a numeric value, NOT function returns error.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_logical_functions.htm
Advertisements