You're an HR analyst assigning year-end bonus tiers from performance review scores. Columns A–B hold 12 employees and their final scores. The tier rules from the comp committee:
| Score range | Tier |
|---|
| 90 and up | A |
| 80 to 89 | B |
| 70 to 79 | C |
| Below 70 | D |
Your task:
- In column C (Bonus Tier), write a formula that returns the right letter for each employee. IFS is the cleanest tool here; nested IF works too.
- The formula must drag-fill from C2 → C13.
Graded cells: C3 (95 → A), C5 (82 → B), C6 (68 → D).
Open this problem on a desktop to attempt it.