An HR analyst's bonus-tier formula is almost right — but it misclassifies every employee whose score lands exactly on a tier boundary. They wrote:
=IF(B2>90, "A", IF(B2>80, "B", IF(B2>70, "C", "D")))
The intent was the standard 4-band rubric:
| Score range | Tier |
|---|
| 90 and up | A |
| 80 to 89 | B |
| 70 to 79 | C |
| Below 70 | D |
But > (strictly greater) instead of >= (greater or equal) drops every boundary value into the wrong tier — score 90 returns "B" instead of "A", score 80 returns "C" instead of "B", score 70 returns "D" instead of "C".
Your task:
- Write a corrected formula in column C (Tier) that uses
>= (or equivalently flips to ascending order with <) so boundary values land in the correct tier.
Graded cells: C2 (90 — boundary), C4 (80 — boundary), C5 (70 — boundary). All three are exactly on a tier boundary, so the broken > formula misclassifies all three.
Open this problem on a desktop to attempt it.