How can I set >= and <= constraints for 1 variable in SOLVER?

**RAISETOWIN** · 02-15-2009, 08:30 PM

How can I set >= and <= constraints for 1 variable in SOLVER?

Say I have a group of variable cells F5:F10. How can I set a constraint for those variables that will keep them between say 4 and 8.

**shg** · 02-15-2009, 08:37 PM

Just set two constraints.

**RAISETOWIN** · 02-15-2009, 09:21 PM

Originally Posted by shg

Just set two constraints.

OK I set two constraints for F5:F10 and it could not find a feasable solution. Now if I do one constraint of F5:F10<=8 it gives a solution. But it does not fit the other requirement of >=4.

Here is the link to my original thread about this optimization problem. If you could look at it and give me some pointers I would appreciate it.

http://www.excelforum.com/excel-prog...lver-help.html

Thank you
Justin