| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate Based on Drop Down Item Selected
If your drop-down is in cell A1, calc could be:
=IF(A1="Low",B1*OtherSheet!A1,IF(A1="Mid",B1*Other Sheet!A2,IF(A1="High",B1*OtherSheet!A3,""))) So if A1 reads "High" the calc multiplies B1 by cell A1, if A1 says "Mid" it multiplies B1 by A2, if A1 says "High" it multiplies B1 by A3, and if it is empty, then it does nothing. "JenB" wrote: 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 |
| Reply |
| 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) | |||
Hybrid Mode
