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.
- All Excel versions
|logical||A value or expression that can be evaluated as TRUE or FALSE.|
- Cheat sheet
The NOT formula returns #VALUE! if an argument doesn't provide a Boolean value.
Empty cells are ignored by the formula.