You're a logistics analyst classifying outbound orders by shipping zone for the warehouse pick-pack queue. Columns A–B hold 12 orders and the distance (miles) to the destination. The zone rubric:
| Distance (mi) | Zone |
|---|
| Below 50 | Local |
| 50 to 499 | Regional |
| 500 and up | National |
Your task:
- In column C (Zone), write an IFS that returns the right zone label for each order.
- The formula must drag-fill from C2 → C13.
Graded cells: C2 (25 → Local), C4 (850 → National), C8 (50 → Regional, boundary).
Open this problem on a desktop to attempt it.