Optimizer saying: "All variables need upper, lower, bounds", even though, they do

**hansaaa** · 07-29-2013, 04:40 PM

Hi,

I am running the solver/optimizer add-in, using evolutionary algorithm.

Here is the configuration:conf.jpg

With clear upper, lower bounds, on the cells $AJ$4, $AJ$5, as far as I can say.

Here is the "message":re.GIF

Why?

Thanks!

C

**shg** · 07-29-2013, 04:58 PM

No knowing what you're trying to do, maybe select a different engine in Solver options, like GRG Nonlinear.

I can't tell from the jpeg, but the upper bound for AJ5 looks odd.

**hansaaa** · 07-29-2013, 05:56 PM

Maybe, these shots, are better:
Config:

Capture.jpg

Message:Capturea.JPG

**shg** · 07-29-2013, 06:19 PM

So replace 10-0.0001 with 9.9999. The constraints are numbers, not expressions.

**ymzkala** · 08-30-2014, 01:41 PM

I have the exact same problem. All of my constraints are numbers, not expressions.

Optimizer saying: "All variables need upper, lower, bounds", even though, they do

LinkBack

Thread Tools

Rate This Thread

Display

Optimizer saying: "All variables need upper, lower, bounds", even though, they do

Re: Optimizer saying: "All variables need upper, lower, bounds", even though, they do

Re: Optimizer saying: "All variables need upper, lower, bounds", even though, they do

Re: Optimizer saying: "All variables need upper, lower, bounds", even though, they do

Re: Optimizer saying: "All variables need upper, lower, bounds", even though, they do

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Determine if a cell value is within upper and lower bounds?

[SOLVED] Multiple if statements with upper/lower bounds

Using MIN on range with upper and lower bounds

Excel 2007 : "UPPER or LOWER" function

[SOLVED] How to fix lower and upper bounds for data

Bookmarks

Bookmarks

Posting Permissions