In Microsoft Excel, when you use the logical functions AND and/or OR inside a SUM+IF statement to test a range for more than one condition, it may not work as expected. A nested IF statement provides this functionality; however, this article discusses a second, easier method that uses the following formulas.

For AND Conditions

This function gives result true only if all conditions are true.

I.e.

Condition 1= True

Condition 2= True

Condition 3=True

Result=True

But if any one condition is false then result is also false.

Condition 1= True

Condition 2= False

Condition 3=True

Result=False

IF (65>50 AND &100==56)

False

Here,condition 1 is true and condition 2 is false , so, result is false

For OR Conditions

This function gives result true even if anyone condition is true.

I.e.

Condition 1= True

Condition 2= True

Condition 3=True

Result=True

But if any one condition is false then result is also false.

Condition 1= True

Condition 2= False

Condition 3=True

Result=False

IF (65>50 AND &100==56)

True

Here,condition 1 is true and condition 2 is false , so, result is True

Not Operator:

This operator gives opposite result.

If condition is true then result is false.

i.e. if (True)

False

Thus, these logical functions are very useful when some condition based statements are needed.