These functions include the Boolean operators and conditional tests.
The functions have been grouped into categories, to help you to find the function you need. Each function name links to a full description of the function, with examples of use.
Excel Logical Functions List




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.
If you like this post then please share and like this post.
You can visit us @ tccicomputercoaching.com
Call us @ 98256 18292.
To Learn More About Basic Computer Course, Computer Course