Solver has 3 options for finding solution for target cell: maximum,
minimum, and value is. 2 separate problems means 2 target
cells(TargetCell1 and TargetCell2). You can create a new target
cell(TargetCell3) and do the following:

Now if TargetCell1 and TargetCell2 are to be "maximum":
TargetCell3 = TargetCell1 + TargetCell2, set TargetCell3 to find the
maximum

If TargetCell1 is to be maximum and TargetCell2 is to be "minimum":
TargetCell3 = TargetCell1 - TargetCell2, set TargetCell3 to find the
maximum

If TargetCell1 is to be maximum and TargetCell2 is to be "value is":
TargetCell3 = TargetCell1 - TargetCell2, set TargetCell3 to find the
maximum

You can figure out the other combinations.


Hope it helps.



Janus Wrote:
Is it possible to have two separate Solver solutions operating in a one
page workbook in Excel 2003? I have two sets of data on one
spreadsheet page both require the use of Solver. The data sets are
independant of each other. I can set Solver to work with one set only
and would like to also use Solver on the other set without creating a
second worksheet. Thanks in advance, Janus


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=401187