Exercises / Logic and decisions · 4 of 9
Free shipping for members or big orders
OR(test1, test2, …) is TRUE when at least one test is TRUE. Text comparisons ignore case: "yes" equals "Yes".
Your taskShipping is free (0) when the order total in B2 is 50 or more, OR the customer is a member (C2 is "Yes"). Otherwise it costs 4.99. Write it in D2 with IF and OR; it will be copied down to D8.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Order | Total | Member | Shipping |
| 2 | #1041 | $72.40 | No | |
| 3 | #1042 | $18.90 | Yes | |
| 4 | #1043 | $50.00 | No | |
| 5 | #1044 | $33.50 | No | |
| 6 | #1045 | $49.99 | No | |
| 7 | #1046 | $120.00 | Yes | |
| 8 | #1047 | $9.50 | yes |