It is exactly that I want thank you
another problem
A has value like below and I want a formula for B's value

A B
Above 7 0
7 0
8 1
6 2
5 3
4 4
3 5
2 6
1 7



"Jacob Skaria" wrote:

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