[SIZE=12px]Hi,
Can someone provide me with a formula that will give me the following scores from these percentage ranges?
Percent Score
<10% 1
10-20% 2
20-30% 3
30-40% 4
40-50% 5
50-60% 6
60-70% 7
70-80% 8
80-90% 9
>90% 10[/SIZE]
I have a column with percentages in. I need the scores to go in the cell to the right