Formula help for distributing values in a row

[simona123]

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Section[/TD]
[TD]Class[/TD]
[TD]Score[/TD]
[TD]Medal[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]#C[/TD]
[TD]9[/TD]
[TD]98[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Daniel[/TD]
[TD]#C[/TD]
[TD]9[/TD]
[TD]98[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jon[/TD]
[TD]#C[/TD]
[TD]9[/TD]
[TD]97[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tom[/TD]
[TD]#C[/TD]
[TD]9

[/TD]
[TD]96[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Alice[/TD]
[TD]#C[/TD]
[TD]9[/TD]
[TD]95[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Elisabeth[/TD]
[TD]#C[/TD]
[TD]9[/TD]
[TD]95[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Robert[/TD]
[TD]#C[/TD]
[TD]9[/TD]
[TD]91[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mertin[/TD]
[TD]#C[/TD]
[TD]9[/TD]
[TD]89[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]etc.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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;">[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]9[/TD]
[/TR]
</tbody>[/TABLE]
</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.