Results of these functions is a logical value (true or false) Comparison operators that can be in logical tests are. Result may be a speci c value or a calculated value. Coutifs, sumifs, averageifs (to be used when multiple criteria are to be tested) Allows you to test the condition of more than just on criterion (condition) Only returns true if all tested values are true. The or function is a logical function that return a true value if any of the logical conditions are true and a false value if all the logical conditions are false or (logical1 [,logical2]) Used when you want to make sure a value is not equal to one particular value. Evaluate whether a condition or a logical test is true or false and returns one value of the condition is true, and other value if the condition is false. If true then value a else value b .