How can use logical Operators with IF Function in Excel

How can use logical Operators with IF Function in Excel

First of all we should know how many types of Logical Operators are there.

Logical Operators:-

= Equal To

> Greater Than

< Less Than

>= Greater Than Equal to

<= Less Than Equal to

<> Not Equal to

We have a small data of cells to understand, from this we will understand how can use logical operator

We want to know which cells have data greater than 50 and which cells have data less than 50.

Note:- Result of Logical Operator is fixed as True and False

Question:- Why do we use IF Function with Logical Operator?

Answer:- Because we need a new result, according to our condition.

Question:- What is the job of IF Function ?

Answer:- Dividing True and False results into separate results.

B2 Cell  "=A2>50"

It means that if A2 is greater than 50 then True answer will come, if A2 is smaller than 50 then False answer will come.

1 means true and 0 means false.

D2 Cell "=IF(B2,"OK","Pending")"

It means that if B2 is True then the answer is "OK", otherwise if B2 is false then the answer is "Pending".

E2 Cell "'=IF(A2>50,"OK","Pending")"

If we use direct if formulas in A2 and how can we use logical operator with it, if condition is True then answer is "OK", otherwise if condition is false then answer comes "Pending"

Conclusions:- 

We have been able to learn the logical operator with the help of easy examples, we also learned how to use it with if formulas