The NOT function is a logical function that returns the opposite of its argument. In this guide, we’re going to show you how to use the NOT formula and also go over some tips and error handling methods.
Supported versions
- All Excel versions
Syntax
NOT(logical)
Arguments
logical | A value or expression that can be evaluated as TRUE or FALSE. |
Examples
Example 1
=NOT(OR(84>=100,78>=100))
Example 2
=IF(OR(NOT("FIRE, FLYING"="Water"),"I"="II",AVERAGE({78,84,78,109,85,100})>=100),"Pass","Fail")
Tips
- Cheat sheet
Calculation | Returns |
NOT TRUE | FALSE |
NOT FALSE | TRUE |
Issues
#VALUE!
The NOT formula returns #VALUE! if an argument doesn't provide a Boolean value.
Empty cells
Empty cells are ignored by the formula.