Problem formula - Is it possible??

tiveytim

New Member
Joined
Jan 13, 2005
Messages
22
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!!!
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Forum statistics

Threads
1,226,719
Messages
6,192,666
Members
453,743
Latest member
ntguy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top