Find cheapest paint order with 'Solver'

Dear Forum.

The subject of this thread is kind of a continuation of a previous thread which had previously been marked as 'Solved'. I am therefore starting this new thread. Here is the link to the previous thread if anyone wanted some background on the topic.

http://www.excelforum.com/excel-new-...int-order.html

shg, if you get the chance, please see the attached workbook which is set up (to my understanding) as you had directed in rows 1-10. I was able to enter the integer constrant after you clarification and now the Solver tool provides results.

However it doesn't seem to be finding the least expensive option. In rows 13-16 I have set up for manual entry (user to input quantities in cells C13-15) to check the Solver's results. It seems to be ignoring the 1000 container option for producing it results as I have yet to see it populate any quantities for 1000 litre containers in it's results.

In the example shown it returns a solution of €88,999.00. User input results €85,000.00.

Any ideas on how to fix as it does indeed seem that this is the 'built in' solution for excel, and would seem to be an excellent tool when dealing with more than the 3 container sizes that my previous thread was based on.

Thank you again for your insight.