View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Help determining a best "lineup"

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
---