maximum / minimum in solver

Basically excel solver is "one goal" oriented.

But you can try to combine your objectives. The way to combine can be different. Basically, multiplication is a good starting point - if you are looking for max of 2 values then you can multiply them and look for the maximum of the product
for instance for
500 0
450 1
400 2
350 3
300 4
250 5
200 6
150 7
100 8
50 9
0 10

max value for both will be for pair
250 5

divide instead of multipluing (provided both values are non-zero and positive)

Formula:

Please Login or Register  to view this content.