| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Based on Drop Down Item Selected
I have a cost estimation worksheet that includes a drop down list. When the user selects from the list, I want to apply a factor based on their selection and multiply it by a total (on a different worksheet). For example, if they select "Low" from the list, I want to multiply 10% by a total cost cell (which is on a different worksheet) and put the result in a different cell. How do I do this? -- JenB ------------------------------------------------------------------------ JenB's Profile: http://www.excelforum.com/member.php...o&userid=37719 View this thread: http://www.excelforum.com/showthread...hreadid=573105 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| refer to drop down item as a sheet reference in a formula | Excel Worksheet Functions | |||
| Selected cells: item count versus summation | Excel Discussion (Misc queries) | |||
| How do I create a macro to return drop down boxes to first item i. | Excel Discussion (Misc queries) | |||
| How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
| How do I calculate charges based on elasped time(H:MM) & rate($)? | Excel Discussion (Misc queries) | |||
Threaded Mode
