View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Solver with If then else?

Excel 2007
Changed goal from minimum production cost
to maximum profit.
Added selling price and cost of excess capacity.
Sensitivity analysis with Monte Carlo method and
multiple regression.
http://c0444202.cdn.cloudfiles.racks...12_15_09a.xlsm