Formula for giving point to particular no.

[kashish]

I have random numbers in A column I want a formula for conditions given below

Percent Point
76-100 1
71-75 2
66-70 3
61-65 4
56-60 5
51-55 6
46-50 7
26-45 8
0-25 9

 

[kashish]

Again thanks but how can i use following formula for ascending order up to
100 and so on
=LOOKUP(A32,{1,2,3,4,5,6,7,8,9,10},{5,10,15,20,25,30,35,40,45,50,55})

 

[Jacob Skaria]

???
=A32*5

If this post helps click Yes