| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a drop down that adds up a price
I'm trying to create a sheet where I have a series of drop down lists where
each item on this drop down when selected gives me a grand total. For example, If I have the options: Apples (.50) Bananas (.75) Cherries (1.00) If I choose apples and cherries in two seperate drop downs, I want to show my grand total as 1.50. I know how to create drop downs and validate the data, but I don't know how to have it reference a price and show a grand running total. Any insight is appreciated! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Create a drop down that adds up a price
Put your options in a little list somewhere. Then use VLOOKUP in the
cells next to your dropdowns to find the prices. And a SUM to add them up. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please help. Need drop down menu for name&price to pop up automat | Excel Worksheet Functions | |||
| Drop down menu along with price | Excel Discussion (Misc queries) | |||
| How do you create a price look up (PLU) file? | Excel Discussion (Misc queries) | |||
| choose a product from a drop down list i need it to insert a price | Excel Worksheet Functions | |||
| create a formula for price * discount* tax =final price | Excel Discussion (Misc queries) | |||
Linear Mode
