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: msgs 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
|
|||
|
|||
You just need to sort your list ascending based on the first column. Then you can use a vlookup as follows: =vlookup(A1, A4:B10,2) The A4:B10 is the area where you have your data table shown in your original post. The vlookup will go to the nearest value that is less than or equal to it and then pull the second column. Let me know if you need a hand. Chad -- cvolkert ------------------------------------------------------------------------ cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380 View this thread: http://www.excelforum.com/showthread...hreadid=381077 |
#3
|
|||
|
|||
How do I get a cell in sheet 4 to = a cell in sheet 2? :) -- sam_360 ------------------------------------------------------------------------ sam_360's Profile: http://www.excelforum.com/member.php...o&userid=24516 View this thread: http://www.excelforum.com/showthread...hreadid=381077 |
#4
|
|||
|
|||
I dunno how we got here, but
=Sheet1!A1 put in any cell in Sheet2 will return the value in Sheet1 cell A1 Vaya con Dios, Chuck, CABGx3 "sam_360" wrote in message ... How do I get a cell in sheet 4 to = a cell in sheet 2? :) -- sam_360 ------------------------------------------------------------------------ sam_360's Profile: http://www.excelforum.com/member.php...o&userid=24516 View this thread: http://www.excelforum.com/showthread...hreadid=381077 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple formula help | Excel Worksheet Functions | |||
help with simple formula | 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 |