Mutiple Table within exel

[Wiggy74]

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