Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Nested IF. To pick between three results, put a second IF where the first IF’s false result goes. Excel checks the tests in order and stops at the first true one, so test the biggest threshold first and work down.
=IF(C2>=90,"A",IF(C2>=75,"B","C")) exam grades
Elena Petrova wants North’s May orders sorted into sizes, so the warehouse can plan pallets for the large ones.
In D2:D13, show "Large" when the order value is at least 500, "Medium" when it is at least 150, and "Small" otherwise.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Customer | Value | Size | ||||
| 2 | 50365 | North Studios | $468.90 | |||||
| 3 | 50366 | Willow Studios | $561.05 | |||||
| 4 | 50373 | Willow Academy | $372.30 | |||||
| 5 | 50383 | Maple Motors | $55.00 | |||||
| 6 | 50385 | Orchard Print Co | $132.00 | |||||
| 7 | 50387 | Oak Fitness | $498.30 | |||||
| 8 | 50389 | Beacon Fitness | $216.70 | |||||
| 9 | 50391 | Silver Pharmacy | $202.50 | |||||
| 10 | 50404 | Pioneer Consulting | $114.00 | |||||
| 11 | 50406 | Oak Labs | $273.31 | |||||
| 12 | 50415 | Blue Accounting | $202.33 | |||||
| 13 | 50422 | Copper Bakery | $302.40 | |||||
| 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