I am trying to exclude a value which is being use for some of my
formulas, using the solver. Is there anyway to add constraints such as
putting the value to Infinity so it would be as good as excluding it?
The value sets the maximum my amount can reach.

Thanks!!


--
aeiou
------------------------------------------------------------------------
aeiou's Profile: http://www.excelforum.com/member.php...o&userid=25595
View this thread: http://www.excelforum.com/showthread...hreadid=394967

aeiou wrote in
:


I am trying to exclude a value which is being use for some of my
formulas, using the solver. Is there anyway to add constraints such as
putting the value to Infinity so it would be as good as excluding it?
The value sets the maximum my amount can reach.

Thanks!!



The largest number in Excel is 9.99999999999999E+307 I seem to remember.


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)