 PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

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

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

• ## NOT FUNCTION IN EXCEL, REVERSE THE VALUE IN EXCEL, EVALUATE ANY CONDITION DIRECTLY

YOU MAY LIKE

LEARN

• EXCEL
• JAVASCRIPT
• MORE TO COME…

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com