Prefer a formula over a lookup

[NeroM]

I’m looking for a formula as opposed to a lookup, but unsure if a formula ill accommodate my conditions!

I’m building a table (see attached) where I could have a percentage value in cells D6 to P6 that ranges from 0 to 100%. In the respective cell beneath each percentile cell (D7 to P7) I need a formula that will return a value of 10 if the percentage in the cell above is 90% or above reducing to 0 points for 80% or below.

So if the percentile value equals 89% then the return would equal 9, 88% would return 8, 87% would return 7, and so on.

My spread sheet is attached, any help would be greatly appreciated.

[romperstomper]

Not sure if you need any rounding, but perhaps:
=MEDIAN(0,10,D6*100-80)

[gak67]

This in D7 and copied across:

Please Login or Register  to view this content.

[NeroM]

Many thanks romperstomper & gak67. Both solutions work exactly as I need.