Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox Values
I have designed an electronic order form that allows the
customer to select a product (from a drop down box) and enter the quantity required. Once the product combo box loses the focus the next cell is supposed to calculate the costs of the items i.e. Total Cost = Price of Product selected * Quatity. In column B7 to B25 is the name of the product and in column C7 to C25 is the price of that product. What combination of formulas would instruct Excel to get the price that corresponds with the product selected in the combobox and complete the calculation? Cheers, D |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox Values
Hi Darren
Assuming the cell link of the combobox is B2, this formula will calculate the price: =INDEX(C7:C25, B2)*Quantity -- Best Regards Leo Heuser MVP Excel Followup to newsgroup only, please. "Darren" skrev i en meddelelse ... I have designed an electronic order form that allows the customer to select a product (from a drop down box) and enter the quantity required. Once the product combo box loses the focus the next cell is supposed to calculate the costs of the items i.e. Total Cost = Price of Product selected * Quatity. In column B7 to B25 is the name of the product and in column C7 to C25 is the price of that product. What combination of formulas would instruct Excel to get the price that corresponds with the product selected in the combobox and complete the calculation? Cheers, D |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using VBA to retrieve values to ComboBox | Excel Discussion (Misc queries) | |||
Using Unique Values in as a combobox value list | Excel Discussion (Misc queries) | |||
Values of ComboBox fields and SQL | Excel Discussion (Misc queries) | |||
Entering Values into Combobox in Spreadsheet | Excel Discussion (Misc queries) | |||
Combobox - use values in excel formula | Excel Worksheet Functions |