Yes
For example
A B
78 1
50 7
65 4
63 4
80 1
23 9


"Stefi" wrote:

Do you mean that if A1 contains 76, the formula should return 1, if A2
contains 71, the formula should return 2, etc.?
Stefi


€žkashish€� ezt Ã*rta:

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