???
=A32*5

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


"kashish" wrote:

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" wrote:

Do you mean

=IF(A28,0,LOOKUP(A2,{1,2,3,4,5,6,7,8},{7,6,5,4,3, 2,0,1}))

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


"kashish" wrote:

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