View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default How do I calculate maximum with variables.

You can certainly do this with Excel's Solver tool!
See these links for information:
http://www.vertex42.com/ExcelArticle...-examples.html
http://support.microsoft.com/kb/843304

Regards,
Ryan---

--
RyGuy


"DanASU" wrote:

How do I find the limits given a set of information. IE x is 100-200, y is
50-300 and x+y=275. x generates $50 per unit and y generates $25 per unit.

Thank you,