IF(OR(E2="CPH",E2="Critical Accuracy",E2="Quality"),LOOKUP(H2,{0,100,111,120},{4,3,2,1})
=IF(OR(E2={"CPH","Critical Accuracy","Quality"}),5-MATCH(H2,{0,1,1.11,1.2}),"not found")
Both work thanks, but i Forgot to include the goal for the metrics.
=IF(OR(E2={"CPH","Critical Accuracy","Quality"}),5-MATCH(H2,{0,1,1.11,1.2}),"not found")
Both work thanks, but i Forgot to include the goal for the metrics.
Tiers | CPH (% to Goal) | Quality | TPR | Utilization | Critical Accuracy |
Tier 1 | 120% | 100% | 110% | 81% | 100% |
Tier 2 | 110% | 97.10% | 100% | 73% | 99.60% |
Tier 3 | 100% | 99.10% | 90% | 70% | 99.10% |
Tier 4 | <100% | <99.1% | <90% | <70% | <99.1% |