Formula for giving point to particular no.

  • Thread starter Thread starter kashish
  • Start date Start date
K

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
 
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})
 
Back
Top