Formula help for distributing values in a row

[simona123]

Name	Section	Class	Score	Medal
Bob	#C	9	98
Daniel	#C	9	98
Jon	#C	9	97
Tom	#C	9	96
Alice	#C	9	95
Elisabeth	#C	9	95
Robert	#C	9	91
Mertin	#C	9	89
etc.

<tbody>
</tbody>

I'm trying to use a formula that allows me to choose the medal (gold, silver, bronze)
gold - for the first 10% of the scores, bronze - for the next 15% and bronze for the next 20%, but I can not figure this out.
****** id="cke_pastebin" style="position: absolute; top: 84px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">

9

<tbody>
</tbody>

</body>

 

[jtakw]

Hi,

Please clarify, when you say "first 10% of the scores, etc." Do you mean based on a scale of all scores in "Score" column, or based on 100 (i.e. 91 to 100)?

 

[simona123]

It's based on a scale of all scores in "Score" column.