View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Billy Liddel Billy Liddel is offline
external usenet poster
 
Posts: 527
Default Using Solver - integer solution

DIL

Set target cell, Equal to: click Value Radio Button and type 1 in InputBox

Regards
Peter

"Dil" wrote:

I am using the solver feature to determine the minimum # of suppliers we need
to fill our demands. When I use my solver solution, it optimizes the number
of suppliers to be .6 of a supplier. Is there a way to force the numbers to
be integers?