Hi,
Firstly sorry about the title - sometimes it's difficult trying to explain what you want.
In my sample file I have three columns with prices for 2 products (Columns BDF). What I would like excel to automatically calculate is whether it is cheaper to buy more of the product for the decreased price or to stick with the quantity required.
For example I have already worked out manually (text in red) that it is cheaper to buy 500 of Product A at the second price (90p) than buying 451 of Product A at the first price (£1).
Is there a way to get excel to calculate this automatically? I would like to use this on a spreadsheet that has 30 items on it and 6 different price breaks. Prices are going up all the time so I don't fancy having to recalculate everytime there is a price increase. i can add as many columns as Excel 2007 will allow.
Any help greatly appreciated - even if it's a resounding NO it can't be done!!
Thanks
Bookmarks