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

CONTENTS

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.
Helpful links for the prerequisites mentioned above

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.

OTHER WAYS TO REACH THIS ARTICLE

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

YOU MAY LIKE

LEARN

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

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: