Problem formula - Is it possible??

[tiveytim]

Hi Again

Problem formula 2 is a lot harder:

I have boxes as below:

Top Bottom Price
12 4 £0
12 12 £6
14 12 £53
24 24 £58
28 12 £64
56 24 £125

the cell with the formula needs to show the price of the box required. e.g if they have 12 at the top and 8 bottom then the box is £6. If they had 24 top and 24 bottom the the price would be 125 as you need the bigger bottom box.

Has anyone any ideas for this. I imagine it is a long formula. If you need more info then let me know.

Many thanks in Advance!!!

 

[Scott Huish]

If they had 24 top and 24 bottom the the price would be 125

Why wouldn't the price for that be 58 as that matches the table exactly?

 

[jdc]

Hi

Yes, need more info, your examples don't match your list

John

 

[just_jon]

Didn't this work?

Perhaps I've misunderstood the requirements?