AND and OR practice exercises
Combine conditions with AND (all must be true) and OR (one is enough), usually inside IF.
- 1Two conditions with ANDA seller gets a bonus only with at least 5 deals AND a rating of at least 4.5. In D2, use IF with AND to show "Yes" or "No".
- 2Either condition with ORPremiumShipping is free for Gold customers OR for orders of 500 or more. In D2, use IF with OR to show "Yes" or "No".
- 3AND and OR in one testPremiumDelivery is free only inside DK, and then only for orders of 500 or more OR for members. In E2, use IF with AND, and OR inside the AND, to show "Free" or "Paid".
- 4Check a value is within limitsPremiumIn E2, show "OK" if the measurement in B2 is between the limits in C2 and D2, both included, and "Check" if not. Both tests must be true, so use AND inside IF.