It behaves like BINARY NOT.
NOT is simply the reverse of a binary value which means
PURPOSE OF NOT IN EXCEL
NOT will reverse TRUE into FALSE and FALSE into TRUE.
PREREQUISITES TO LEARN NOT
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Some information about the BINARY MATHEMATICS is an advantage for the use of such formulas.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Of course, Excel software.
Helpful links for the prerequisites mentioned above
What Excel does? How to use formula in Excel?
SYNTAX: NOT FUNCTION
The Syntax for the function is
BINARY CONDITION= ANY CONDITION WHICH WILL RESULT IN TRUE OR FALSE
EXAMPLE:NOT FUNCTION IN EXCEL
We can check any binary condition (which results in true or false)
The condition is TRUE. so the result will be False.
Any simple condition can be put directly using the logical operators.
e.g. not(any cell value < any value)