Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down Box / Functions
HELP Please
This is what I would like to do... Example: "C6" is a drop down menu for design type Designs are listed as 4000, 6000, 3500...Each have a deferent price/per that needs up dating I don't want to put in cost every time I price out a job. I would like "4000" in the drop down menu to refer to cell "G15" where the price / per is entered when price is updated So in Total price (Lets say cell "F24") "F24" would be =SUM(C6, (K5:K11))*C9 (C9 amount of) 6000 would be "G16", 3500 "G17.... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down Box / Functions
Your query isn't clear.
"C6 is a dropdown menu" Are you using data validation? Where is the list. Is it in column F (ie adjacent to the prices)? "=SUM(C6, (K5:K11))*C9" - what is in K5:K11? Assuming I am correct in my assumptions above, you need to use data validation to fill the drop down menu from column F15, F16, F17 etc, then use =VLOOKUP(C6,F15:G17,2,FALSE)*C9 in F24 -- Ian -- "KG121953" wrote in message ... HELP Please This is what I would like to do... Example: "C6" is a drop down menu for design type Designs are listed as 4000, 6000, 3500...Each have a deferent price/per that needs up dating I don't want to put in cost every time I price out a job. I would like "4000" in the drop down menu to refer to cell "G15" where the price / per is entered when price is updated So in Total price (Lets say cell "F24") "F24" would be =SUM(C6, (K5:K11))*C9 ("C9" amount of) 6000 would be "G16", 3500 "G17".... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down Box / Functions
I don't know if this will clear this up
Example; Cell C6 is drop Down box Created in data validation C9 is where I would inter the # of units F4 would then be the total cost when updating my suplier price list I would then enter the design cost in cells as fallows 4000 G15, 6000 G18, 3500 G19...... C9 list woud read 4000, 6000, 3500.... By choosing 4000 the value of C6 would be the same as G15 (K5:K11) are cell that I would enter other price factors } Yes I know "I'm not the sharpest knife in the draw. Thank for your resonce I hope that this helped clear things up "Ian" wrote: Your query isn't clear. "C6 is a dropdown menu" Are you using data validation? Where is the list. Is it in column F (ie adjacent to the prices)? "=SUM(C6, (K5:K11))*C9" - what is in K5:K11? Assuming I am correct in my assumptions above, you need to use data validation to fill the drop down menu from column F15, F16, F17 etc, then use =VLOOKUP(C6,F15:G17,2,FALSE)*C9 in F24 -- Ian -- "KG121953" wrote in message ... HELP Please This is what I would like to do... Example: "C6" is a drop down menu for design type Designs are listed as 4000, 6000, 3500...Each have a deferent price/per that needs up dating I don't want to put in cost every time I price out a job. I would like "4000" in the drop down menu to refer to cell "G15" where the price / per is entered when price is updated So in Total price (Lets say cell "F24") "F24" would be =SUM(C6, (K5:K11))*C9 ("C9" amount of) 6000 would be "G16", 3500 "G17".... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down Box / Functions
I may be misunderstanding, but if you have the data validation drop down in
C6, you can't have the value of another cell in there as well. You need to relate G15 with 4000, G18 with 6000 etc., but I don't see how you are doing that. What you would need is a table with the designs in one column and the prices in the next (ie 4000 in F15, 6000 in G18 etc), then use a vlookup similar to the one I suggested. Your "other price factors" remain a confusion. What are they, and what are you doing with them? Are they multiplication factors? If so, what are you multiplying? -- Ian -- "KG121953" wrote in message ... I don't know if this will clear this up Example; Cell C6 is drop Down box Created in data validation C9 is where I would inter the # of units F4 would then be the total cost when updating my suplier price list I would then enter the design cost in cells as fallows 4000 G15, 6000 G18, 3500 G19...... C9 list woud read 4000, 6000, 3500.... By choosing 4000 the value of C6 would be the same as G15 (K5:K11) are cell that I would enter other price factors } Yes I know "I'm not the sharpest knife in the draw. Thank for your resonce I hope that this helped clear things up "Ian" wrote: Your query isn't clear. "C6 is a dropdown menu" Are you using data validation? Where is the list. Is it in column F (ie adjacent to the prices)? "=SUM(C6, (K5:K11))*C9" - what is in K5:K11? Assuming I am correct in my assumptions above, you need to use data validation to fill the drop down menu from column F15, F16, F17 etc, then use =VLOOKUP(C6,F15:G17,2,FALSE)*C9 in F24 -- Ian -- "KG121953" wrote in message ... HELP Please This is what I would like to do... Example: "C6" is a drop down menu for design type Designs are listed as 4000, 6000, 3500...Each have a deferent price/per that needs up dating I don't want to put in cost every time I price out a job. I would like "4000" in the drop down menu to refer to cell "G15" where the price / per is entered when price is updated So in Total price (Lets say cell "F24") "F24" would be =SUM(C6, (K5:K11))*C9 ("C9" amount of) 6000 would be "G16", 3500 "G17".... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
math functions in a drop down menu? | Excel Discussion (Misc queries) | |||
if functions involving drop down lists. | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Drop Down button with functions? | Excel Worksheet Functions |