# EXCEL FUNCTIONS-NOT

## 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.

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.