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

INTRODUCTION TO FORMULAS:LOGICAL OPERATORS

A BRIEF INTRODUCTION TO FORMULAS WAS ALREADY GIVEN IN THE VERY FIRST POST What Excel does? How to use formula in Excel?
ARITHMETIC OPERATORS WERE ALREADY DISCUSSED IN THE PREVIOUS POST INTRODUCTION TO EXCEL FORMULAS:ARITHMETIC OPERATORS

BUT THAT’S NOT ALL. WE HAVE GOT LOGICAL OPERATORS TOO WITHOUT WHICH WE WON’T BE ABLE TO DO EVERYTHING IN EXCEL. SO LET US TRY TO LEARN LOGICAL OPERATORS TOO.

 

WHAT ARE LOGICAL OPERATORS IN EXCEL?

LOGICAL OPERATORS are the ones which tells us about the condition of the statement.
e.g. equal to, greater than, less than, greater than or equal to, less than or equal to,not equal to etc.
Logical operators have got much importance in excel because in most of the functions we have to check the situation before performing any action. In real life too, we have to test before we act. The same is the situation here.
If we want to make smart reports, we have to check different conditions and apply different operations on them.
So logical operators help us to check the conditions of data.

LOGICAL OPERATORS PERMITTED IN EXCEL

Following operators are permitted in Excel formula

 

OPERATOR FUNCTION
=
EQUAL TO
>
GREATER THAN
>=
GREATER THAN OR EQUAL TO
<
LESS THAN
<=
LESS THAN OR EQUAL TO
<>
NOT EQUAL TO

LOGICAL OPERATORS: DESCRIPTION

EQUAL TO-"="

“=” 

is a logical operator which is used when we have to check if something is equal to a particular value or not.

It’ll be used with functions like IF and other functions, which will be discussed in further posts.

USAGE:

We sometimes can use this operator for a case when we need to check the value of some cell.

Let us take a case.

We will check if cell A13 is containing the value 12 or not.

=if(A13=12,true,false).

The answer will appear as true as we have put A13 content as number 12.

 

GYANKOSH EQUAL OPERATOR
EXAMPLE:"=" OPERATOR

GREATER THAN

“>” 

is a logical operator which is used when we have to check if something is GREATER THAN a particular value or not.

It’ll be used with functions like IF and other functions, which will be discussed in further posts.

USAGE:

WE HAVE A VALUE OF 15 IN G10.
WE’LL CHECK IF VALUE IN G10 IS GREATER THAN 10 OR NOT.
We’ll put a formula in a cell, where we want the result,and put following formula.
=If(G10>10,true,false)
The result will come as TRUE.

 

 

GYANKOSH GREATER THAN OPERATOR
EXAMPLE:">" OPERATOR

GREATER THAN or equal to

“>=” 

is a logical operator which is used when we have to check if something is GREATER THAN OR EQUAL TO a particular value or not.

It’ll be used with functions like IF and other functions, which will be discussed in further posts.

USAGE:

WE HAVE A VALUE OF 3 IN G10.
WE’LL CHECK IF VALUE IN G10 IS GREATER THAN 10 OR NOT.
We’ll put a formula in a cell, where we want the result,and put following formula.
=If(G10>=10,true,false)
The result will come as FALSE.

 

GYANKOSH GREATER THAN OR EQUAL TO OPERATOR
EXAMPLE:">=" OPERATOR

LESS THAN

“<” 

is a logical operator which is used when we have to check if something is LESS THAN a particular value or not.

It’ll be used with functions like IF and other functions, which will be discussed in further posts.

USAGE:

WE HAVE A VALUE OF 6 IN G10.
WE’LL CHECK IF VALUE IN G10 IS LESS THAN 10 OR NOT.
We’ll put a formula in a cell, where we want the result,and put following formula.
=If(G10<10,true,false)
The result will come as TRUE.

 

LESS THAN OPERATOR IN EXCEL
EXAMPLE:"<" OPERATOR

LESS THAN OR EQUAL TO

“<=” 

is a logical operator which is used when we have to check if something is LESS THAN OR EQUAL TO a particular value or not.

It’ll be used with functions like IF and other functions, which will be discussed in further posts.

USAGE:

WE HAVE A VALUE OF 10 IN G10.
WE’LL CHECK IF VALUE IN G10 IS LESS THAN OR EQUAL TO 10 OR NOT.
We’ll put a formula in a cell, where we want the result,and put following formula.
=If(G10<=10,true,false)
The result will come as TRUE.

 

LESS THAN OR EQUAL TO OPERATOR
EXAMPLE:"<=" OPERATOR

NOT EQUAL TO

“<>” 

is a logical operator which is used when we have to check if something is NOT EQUAL TO a particular value.

It’ll be used with functions like IF and other functions, which will be discussed in further posts.

USAGE:

WE HAVE A VALUE OF 2019 IN G10.
WE’LL CHECK IF VALUE IN G10 IS NOT EQUAL TO 2019 OR NOT.
We’ll put a formula in a cell, where we want the result,and put following formula.
=If(G10<>2019,true,false)
The result will come as FALSE.

 

 

NOT EQUAL TO OPERATOR IN EXCEL
EXAMPLE:"<>" OPERATOR

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: