CSE 2111 Lecture 6: Boolean Functions Exercise

32 views4 pages
Verified Note

Document Summary

Boolean expressions exercise: write a formula in cell analysis!b3, which can be copied down, to determine (t/f) if the corresponding student organization traveled to all 3 locations. Lecture 6: write a formula in cell analysis!c3, which can be copied down, to determine (t/f) if the corresponding student organization traveled to either italy or france. Answer: =or(trips!b3>0,trips!d3>0: write a formula in cell analysis!d3, which can be copied down, to determine (t/f) if the corresponding student organization did not travel to any of the 3 locations. Lecture 6: write a formula in cell analysis!e3, which can be copied down, to determine (t/f) if the corresponding student organization traveled to 2 or more locations. Answer: =countif(trips!b3:d3, >0 )>=2: write a formula in cell analysis!f3, which can be copied down, to determine (t/f) if there were more trips to italy than spain for the corresponding student organization.

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