software

I need to know how to set up a price sheet that when a customer on line
changes the quantity so does the price.

gt; I need to know how to set up a price sheet that when a customer on line
gt; 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,quot;=VLOOKUP(A2,A$10:B$13,2,FALSE)quot;,=C2*B2,
Parsley,2,quot;=VLOOKUP(A3,A$10:B$13,2,FALSE)quot;,=C3*B3,
Rosemary,8,quot;=VLOOKUP(A4,A$10:B$13,2,FALSE)quot;,=C4*B4 ,

,,,=SUM(D24),=quot;Grand Totalquot;,Unit Price,,,
Parsley,12,,,
Sage,13,,,
Rosemary,14,,,
Thyme,15,,,