Try this with value in A1

=LOOKUP(A1,{0,26,46,51,56,61,66,71,76},{9,8,7,6,5, 4,3,2,1})

If this post helps click Yes
---------------
Jacob Skaria


"kashish" wrote:

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