INTRODUCTION
It behaves like BINARY NOT.
NOT is simply the reverse of a binary value which means
TRUE NOT=FALSE
AND
FALSE NOT=TRUE.
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
=NOT(BINARY CONDITION)
BINARY CONDITION= ANY CONDITION WHICH WILL RESULT IN TRUE OR FALSE
EXAMPLE:NOT FUNCTION IN EXCEL
DATA SAMPLE
We can check any binary condition (which results in true or false)
e.g.
=NOT(5*3=15)
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)
etc.