Excel 2007 : calculating numbers needed to achieve best result

I need to find a way to quickly calculate which numbers I need to put into column F to achieve the highest number possible in H11. Column F can contain any numbers between 300 and 420 but column G has to add up to a specified number that will vary from day to day. The numbers in column A and column B will also vary from day to day.


Any help would be greatly appreciated, even if it's just a suggested jumping off point.
Thank You!!

I'd google linear programming and excel.

Welcome to the forum.

Use Solver. See http://office.microsoft.com/en-us/ex...001124595.aspx.

E.g., maximize H11 by changing F1:F10, subject to the constraints

F1:F10 >= 320
F1:F10 <= 400
G11 = 800000

Please Login or Register  to view this content.