Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
AND and OR. AND(test1, test2) is TRUE only when every test is true. OR(test1, test2) is TRUE when at least one is. Put either one inside IF as the test.
=IF(AND(B2="West",D2>100),"Big West","")
Customer care calls every customer whose order was refunded or cancelled. They want a simple Yes/No column.
In E2:E12, show "Yes" when the status (C) is "refunded" or "cancelled", otherwise "No".
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Region | Status | Value | Follow up? | |||
| 2 | 50484 | East | completed | 18.05 | ||||
| 3 | 50485 | South | completed | 37.2 | ||||
| 4 | 50486 | East | cancelled | 110 | ||||
| 5 | 50487 | South | completed | 260.2 | ||||
| 6 | 50488 | East | completed | 129 | ||||
| 7 | 50508 | North | refunded | 271.8 | ||||
| 8 | 50509 | South | completed | 824.7 | ||||
| 9 | 50510 | South | completed | 466.38 | ||||
| 10 | 50517 | South | refunded | 343.7 | ||||
| 11 | 50518 | West | completed | 31 | ||||
| 12 | 50526 | West | refunded | 231.5 | ||||
| 13 | ||||||||
| 14 | ||||||||
| 15 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe