I want a cell to diplay text based upon a % in another cell I want column B to s

Question

I want a cell to diplay text based upon a % in another cell

I want column B to show the Text Red, Yellow, Green or Gold based upon % in column E.

Thanks !!

AGM Rating # of Stores Green or Gold # of Stores Total % Star Performance Number of RED Stores Nichols Yellow 5 9 55.56% 2 Williams Red 1 8 12.50% 3 Hager Red 4 9 44.44% 3 Scott Yellow 6 10 60.00% 1 Matthews Yellow 5 9 55.56% 2 Kennedy Red 3 9 33.33% 0 Landis Gold 8 9 88.89% 1 Campbell Red 2 9 22.22% 2 Phelps Red 4 10 40.00% 1 Region Red 38 82 46.34% 15

Explanation / Answer

Hi..

Hi,

Put this in B2 and drag down.

=LOOKUP(E2,{0,0.55,0.7,0.8},{"Red","Yellow","Green","Gold"})

NOTE..... You didn't tell us the REAL thresholds for each level so I chose this

0 = Red

55%= Yellow

70% - Green

80% =Gold

the % in the formula are in decimal so make sure they are correct.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.