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!!!
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!!!