Forgot one thing when the situation is TargetCell1="maximum" and
TargetCell2="value is"

You need to set up a new constraint for TargetCell2:
ie. TargetCell2 = your target value.


Morrigan Wrote:
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.


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