Classify deliveries against an SLA
Your goal: Separate unfinished deliveries, missing measurements and genuine zero-hour observations before deciding whether a completed delivery is late.
Full task requirements
Fill D2:D8. For Delivered rows, show Late only when numeric nonnegative hours exceed G2; otherwise show On target. Show Review data for an invalid completed measurement and Not completed for every other state.
Boundary, blank and unfinished casesStart with completed deliveries
- State
- Delivered
| # | ||
|---|---|---|
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 | ||
| 6 | ||
| 7 | ||
| 8 |
Step 1 of 4
Start with completed deliveries
How the Excel rule works
Select completed records first. Every other state returns Not completed, regardless of its hours.
Inspect selected records
No records selected yet.