Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Also read about Tolerance. Use Tools | Solver | Options | Help and you will
find Tolerance:The percentage by which the target cell of a solution satisfying the integer constraints can differ from the true optimal value and still be considered acceptable. This option applies only to problems with integer constraints. A higher tolerance tends to speed up the solution process best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dil" wrote in message ... 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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Solver bug - Won't return Integer | Excel Discussion (Misc queries) | |||
Solver solution hessian | Excel Discussion (Misc queries) | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
Solver does not find correct solution??? | Excel Discussion (Misc queries) | |||
Problem with Solver and Integer constraints | Excel Worksheet Functions |