| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas with drop down list data
I've entered a drop down list with percentages as options (5%, 10%, 15% etc.)
Is there a way to add a formula based on the selection in the drop down list? I want the formula to multiply the percentage selected in my dropdown list by the total amount in cell C63. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas with drop down list data
Just multiply the two.
A1 = drop down list cell =A1*C63 -- Biff Microsoft Excel MVP "Formulas with drop down list data" <Formulas with drop down list wrote in message ... I've entered a drop down list with percentages as options (5%, 10%, 15% etc.) Is there a way to add a formula based on the selection in the drop down list? I want the formula to multiply the percentage selected in my dropdown list by the total amount in cell C63. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Data from Drop Down Menus in Sum Formulas | Excel Worksheet Functions | |||
| How do i set up a drop down list and hide my list data. | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
| Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
| formulas involving a drop down list | Excel Worksheet Functions | |||
Linear Mode
