Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with simple formula | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Excel Miscalculates simple formula..Help!! | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |