Return text from three data points

[jessilee17]

I am trying to create a formula that looks at I3:K3 and returns text. L3 would be bronze if all scores are 3 or higher, L3 would be Silver if all cells are 4 or higher, L3 is Gold if all cells are 5 or higher, L3 would be Platinum if all cells are 6 or higher.Currently I used an If (or ... but it is only looking at I3, not I3:K3. For example, L6 is returning Platinum due to I6, but it should return Gold because J6 and K6 are a 5.

 

[Eric W]

Welcome to the MrExcel forum!

Try:

Book1 (version 1).xlsb
	I	J	K	L
1	Math	Graphic Literacy	Workplace Documents	Certificate
2
3	4	3	3	Bronze
4	3	5	3	Bronze
5	4	4	4	Silver
6	6	5	5	Gold
7	4	5	3	Bronze
8
9	3	3	3	Bronze
10	5	5	5	Gold
11
12	6	3	5	Bronze
13	3	3	3	Bronze
Sheet2

Cell Formulas
Range	Formula
L3:L13	L3	=IFERROR(CHOOSE(MIN(I3:K3),"","","Bronze","Silver","Gold","Platinum"),"")