Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
IFS. IFS takes pairs: a test, then the result if it is true. It returns the result of the first true test, so it replaces a chain of nested IFs. When no test is true it gives #N/A, so many people end with TRUE as a catch-all last test.
=IFS(B2>=1000,"Gold",B2>=500,"Silver",TRUE,"Bronze")
Brightline is reviewing Greenway Logistics. Operations wants each March delivery rated against the days the customer was promised.
In D2:D13, show "Early" when the days taken (C) are fewer than the promised days (B), "On time" when they are equal, and "Late" when they are more.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Promised days | Days taken | Rating | ||||
| 2 | 50183 | 3 | 1 | |||||
| 3 | 50186 | 3 | 3 | |||||
| 4 | 50196 | 3 | 1 | |||||
| 5 | 50198 | 5 | 5 | |||||
| 6 | 50201 | 5 | 5 | |||||
| 7 | 50202 | 3 | 3 | |||||
| 8 | 50206 | 3 | 2 | |||||
| 9 | 50209 | 3 | 1 | |||||
| 10 | 50214 | 3 | 1 | |||||
| 11 | 50215 | 3 | 6 | |||||
| 12 | 50217 | 3 | 1 | |||||
| 13 | 50222 | 5 | 7 | |||||
| 14 | ||||||||
| 15 | ||||||||
| 16 |
=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