Simple formula help

Z

zero

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?
 
C

CLR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple formula help 3
Help Creating Excel Formula 4
function range 1
Error with sum formula in excel 2007 4
function range 2
Vlookup with If condition 1
Formula help 1
Excel Need Countifs Formula Help 0

Top