View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.charting
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Solver not working

Excel 2007
Yes, Goal Seek has only one variable,
but a workaround is iteration and RMS.
Illustrated that by adding two more columns.
Graphed it for visualization.
Solution has a range of values.
http://c0444202.cdn.cloudfiles.racks...12_07_09a.xlsm