ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Inifinity value? URGENT! (https://www.excelbanter.com/excel-discussion-misc-queries/39915-inifinity-value-urgent.html)

aeiou

Inifinity value? URGENT!
 

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


Dodo

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)


All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com