SheetsdrillFree shipping rule
A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Shipping is "Free" when the order total is at least the minimum in G1 or the customer is a member ("Yes"), but never when the destination is "Intl". Everything else is "Paid". Fill E2 and E3 with formulas that could be filled down.
What this exercise teaches
AND and OR take any number of conditions, and they nest. Writing the rule as AND(OR(...), ...) mirrors the sentence, which is easier to check than a chain of nested IFs.
A hint if you get stuck
Build the test from the inside out: OR(total test, member test) is one condition, the destination test is another, and AND joins them. The IF goes around all of it.
Try it now, free, no account needed
The first 15 tasks on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro adds timed mode and the certificate.
Open this exerciseMore exercises in Conditional counting and summing
- Open high-priority ticketsPro
- Sales for one rep and monthPro
- Won deals above a minimumPro
- Average reply timePro
- Largest order in a regionPro
- Cheapest item in stockPro
- Orders between two datesPro
- Customer tiers with IFSPro
- Region names with SWITCHPro
- Contacts on one email domainPro
- Active SKUs with a prefixPro
- Weighted average scorePro
- Rank without RANKPro