Home |
Search |
Today's Posts |
#1
|
|||
|
|||
much needed If/or statement help
Hello, I am not an experienced excel user however I need to find a way for excel to do a function for me and I have had no luck with if/then/or statements. My question is this. I need a function that will if I pick a selection off a drop down list present me with a value associated with it. For example. I have different machine sizes 110,245,385,500,720 and 950 they are in a drop down list. I need to associate electric rates to each of them. 110 = 4.00 245=4.50 385=5.00 500=5.50 720=6.00 and 950 = 6.50. So when I pick the machine size off of my drop down list in say cell c3 I need the electric rate to display in cell d14. Could anyone please help me. I have a feeling this may be a Visual Basic type formula, but I am even less experienced at that. thank you. ~ Jason Gross -- Yupkwondo ------------------------------------------------------------------------ Yupkwondo's Profile: http://www.excelforum.com/member.php...o&userid=26391 View this thread: http://www.excelforum.com/showthread...hreadid=396702 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom percent format needed | Excel Worksheet Functions | |||
Help in getting external data needed please | Excel Worksheet Functions | |||
help with forumla needed... getting a yes/no answer to ?? | Excel Worksheet Functions | |||
Pivot Table Assistance Needed | Excel Worksheet Functions | |||
Pivot Table Assistance Needed | Excel Worksheet Functions |