| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a price sheet in excel.
I need to know how to set up a price sheet that when a customer on line
changes the quantity so does the price. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I set up a price sheet in excel.
I need to know how to set up a price sheet that when a customer on line
changes the quantity so does the price. The example in the CSV file below might suggest a useful approach. The unit price lookup table might be on a separate worksheet if that's more convenient. -------------- cut here -------------- Description,Qty,Unit Price,Subtotal, Thyme,4,"=VLOOKUP(A2,A$10:B$13,2,FALSE)",=C2*B2, Parsley,2,"=VLOOKUP(A3,A$10:B$13,2,FALSE)",=C3*B3, Rosemary,8,"=VLOOKUP(A4,A$10:B$13,2,FALSE)",=C4*B4 , ,,,=SUM(D2:D4),="Grand Total" ,Unit Price,,, Parsley,12,,, Sage,13,,, Rosemary,14,,, Thyme,15,,, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Confusing Invisible Excel Sheet | Excel Discussion (Misc queries) | |||
| Price Comparison Macro - This Is For An Excel MVP | Excel Discussion (Misc queries) | |||
| Excel - automatic information from one sheet to another?? | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Unable to open excel sheet in Protected mode from VB 6.0 | Setting up and Configuration of Excel | |||
Linear Mode
