And if you want it the other way for the objective, ie maximize "Sum of
Results" (instead of minimize), just replace the model's formulae in both M2
and S1 with "MAX", viz:
In M2: =MAX(K:K)
In S1: =MAX(Q:Q)
Playing with maximization here reveals a possible best combo pick of cars #:
16,17,18,19,20 satisfying the criteria (Sum of "Values" < 100) with a max
"Sum of Results" of 3984.6.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---