| 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.... |
| 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 | |||
Threaded Mode
