Good afternoon all
I have a price list I need to put together for a client, which is automated as far as possible. There are a number of variables to consider though. I basically have 4 products, lets call them A, B, C & D. Then for each product, there is a quantity range, 1 - 99, 100 - 149, 150 - 199, 200 - 249 and then finally 250+. For each price bracket, there is a different unit price.
I have created a table on the spreadsheet as follows:
Pages 1 - 99 100 - 149 150 - 199 200 - 249 250+
4 0.50 0.48 0.42 0.34 0.28
8 0.72 0.65 0.48 0.40 0.34
12 0.92 0.85 0.67 0.60 0.54
16 1.10 1.02 0.89 0.78 0.73
Does anyone know how can I create an automated spreadsheet so the client can enter the number of pages and the quantity and it will give them the price. I know I can do nested IF Statements, but this seems very long winded?
Any ideas would be welcomed.
Kind regards,
Craig
Bookmarks