Simple formula help
 

Hi

I need a simple fórmula that takes a value from a cell (A1 would be fine)
and put a value to other Cell (A2 it's ok) considering what this number is,
and then assigning a value from this table:

messages value
10000 10
5000 10
4000 9
3000 9
2500 9
2000 8
1500 7
1200 6
1000 5
800 5
600 4
400 3
300 3
200 2
100 1
50 1
0 0


IE: if the A1 cell value is 5500 messages, A2 should be 10
If A1 cell value is 3500 messages, A2 should be 9 and so on.

How can I do that?

Look at Help for VLOOKUP.

------

Vasant

"zero" wrote in message
...
Hi

I need a simple fórmula that takes a value from a cell (A1 would be fine)
and put a value to other Cell (A2 it's ok) considering what this number
is,
and then assigning a value from this table:

messages value
10000 10
5000 10
4000 9
3000 9
2500 9
2000 8
1500 7
1200 6
1000 5
800 5
600 4
400 3
300 3
200 2
100 1
50 1
0 0


IE: if the A1 cell value is 5500 messages, A2 should be 10
If A1 cell value is 3500 messages, A2 should be 9 and so on.

How can I do that?

Put your table in range G1:H17, and reverse it to be ascending rather than
decending,
Then in A2 put this formula

=VLOOKUP(A1,G1:H18,2,TRUE)

Vaya con Dios,
Chuck, CABGx3



"zero" wrote in message
...
Hi

I need a simple fórmula that takes a value from a cell (A1 would be fine)
and put a value to other Cell (A2 it's ok) considering what this number
is,
and then assigning a value from this table:

messages value
10000 10
5000 10
4000 9
3000 9
2500 9
2000 8
1500 7
1200 6
1000 5
800 5
600 4
400 3
300 3
200 2
100 1
50 1
0 0


IE: if the A1 cell value is 5500 messages, A2 should be 10
If A1 cell value is 3500 messages, A2 should be 9 and so on.

How can I do that?