IFS practice exercises
Returns the value for the first test that is TRUE. Work through these on the table below, then check each answer.
Practise interactively Type formulas into a live sheet with instant feedback. Free.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Rep | Units | Price | Revenue |
| 2 | 2301 | North | Lena | 2 | 60 | 120 |
| 3 | 2302 | West | Lena | 4 | 18 | 72 |
| 4 | 2303 | North | Raj | 2 | 45 | 90 |
| 5 | 2304 | West | Maya | 9 | 45 | 405 |
| 6 | 2305 | South | Raj | 7 | 30 | 210 |
| 7 | 2306 | East | Maya | 1 | 18 | 18 |
| 8 | 2307 | West | Omar | 4 | 18 | 72 |
| 9 | 2308 | East | Omar | 2 | 15 | 30 |
Label order 2303: "Large" if Revenue is at least 100, "Medium" if at least 50, otherwise "Small".
Show answer
=IFS(F4>=100,"Large",F4>=50,"Medium",TRUE,"Small")→ MediumLabel order 2301: "Large" if Revenue is at least 100, "Medium" if at least 50, otherwise "Small".
Show answer
=IFS(F2>=100,"Large",F2>=50,"Medium",TRUE,"Small")→ LargeLabel order 2302: "Large" if Revenue is at least 100, "Medium" if at least 50, otherwise "Small".
Show answer
=IFS(F3>=100,"Large",F3>=50,"Medium",TRUE,"Small")→ MediumLabel order 2304: "Large" if Revenue is at least 100, "Medium" if at least 50, otherwise "Small".
Show answer
=IFS(F5>=100,"Large",F5>=50,"Medium",TRUE,"Small")→ LargeLabel order 2305: "Large" if Revenue is at least 100, "Medium" if at least 50, otherwise "Small".
Show answer
=IFS(F6>=100,"Large",F6>=50,"Medium",TRUE,"Small")→ LargeLabel order 2306: "Large" if Revenue is at least 100, "Medium" if at least 50, otherwise "Small".
Show answer
=IFS(F7>=100,"Large",F7>=50,"Medium",TRUE,"Small")→ Small
New to IFS? Read the IFS guide first: syntax, a worked example and common mistakes.