| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
assign Drop Down selections with values
Not sure if this can be done..
Looking to assign drop down selections a "value" for which, once selected, can be multiplied by different cells to come up with an extension. More like assigning a menu of words with a value and then once user selects that specific item along with another drop down value, an extension appears. For Example Tickets to Rome- $590.00 each Tickets to Paris- $400.00 each Tickets to New York-$320.00 each Multiple by: 1 Round Trip Passenger 2 Round Trip Passengers 3 Round Trip Passengers Equals= Extension. Possible through Excel? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
assign Drop Down selections with values
What is an "extension"??
On Mar 10, 2:44*pm, Assigning drop down selections w / Value <Assigning drop down selections w / wrote: Not sure if this can be done.. Looking to assign drop down selections a "value" for which, once selected, can be multiplied by different cells to come up with an extension. * More like assigning a menu of words with a value and then once user selects that specific item along with another drop down value, an extension appears. For Example * *Tickets to Rome- $590.00 each * *Tickets to Paris- $400.00 each * *Tickets to New York-$320.00 each *Multiple by: * *1 Round Trip Passenger * *2 Round Trip Passengers * *3 Round Trip Passengers Equals= Extension. Possible through Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list selections creating values in adjoining cell | Excel Worksheet Functions | |||
| How do I assign a set of values to a selection from a drop list? | New Users to Excel | |||
| How to equate Text Drop Down selections to numerical values | Excel Discussion (Misc queries) | |||
| Assign values to names in a drop-down list? | Excel Discussion (Misc queries) | |||
| How do I use drop down list selections/values in a vlook up formu. | Excel Discussion (Misc queries) | |||
Linear Mode
