Simple formula help

Look at Help for VLOOKUP.

------

Vasant

"zero" <repyl@newsgroup.please> wrote in message
news:%23O0GXZrdFHA.2880@TK2MSFTNGP10.phx.gbl...
> 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" <repyl@newsgroup.please> wrote in message
news:#O0GXZrdFHA.2880@TK2MSFTNGP10.phx.gbl...
> 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?
>
>

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" <repyl@newsgroup.please> wrote in message
news:%23O0GXZrdFHA.2880@TK2MSFTNGP10.phx.gbl...
> 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" <repyl@newsgroup.please> wrote in message
news:#O0GXZrdFHA.2880@TK2MSFTNGP10.phx.gbl...
> 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?
>
>