ADM 1370 Lecture Notes - Lecture 12: Calcite, Portable Document Format

76 views4 pages

Document Summary

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 .

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents

Related Questions