Excel Solver Constraints

J

jcoleman52

Hello:

I am using Excel solver function for curve-fitting, and would like to
set a constraint for a value to be greater than 0. However, it appears
that solver will only allow greater-than-or-equal-to in a constraint.
Unfortunately, if the value equals zero, the equation bombs out. Does
anyone know of any way to set a constraint to simply greater than (or
less than for that matter)? Thanks.
 
M

MrShorty

As far as Excel is concerned, the statement "x>0" is the same as
"x>=2.2E-308" (the smallest positive number Excel can recognize).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: Creating a macro that will run Solver. 0
Excel 2007: Help creating a macro that will run Solver? 3
Excel 2007: Help creating a macro that will run Solver? 0
Solver Constraints 2
Greater Less or Equal 3
Solver Ignores Constraints 1
Critical path affected by constraints 0
Critical Path affected by Constraints 0

Top