optimization
 

i was wondering if anyone knew of a macro formula or any formula tha
would create an optimization button so that whenever you clicked th
button it would select the best combination of three values in d2:f2 s
that i2 will be the most minumum value possibl

--
kcka
-----------------------------------------------------------------------
kckar's Profile: http://www.excelforum.com/member.php...fo&userid=2532
View this thread: http://www.excelforum.com/showthread.php?threadid=39418

optimization
 

Help us understand what you are asking. D2:F2 is only thre
cells...therefore whatever the SUM of those three cells...it is th
minimum (and for that matter, the maximum) it can be.

What are we missing?

I2=SUM(D2:F2)

More info, pleas

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=39418

optimization
 

its kind of complex

basically i am creating a forecast model where d2:f2 alpha, beta an
delta values. (that all alter the forecast)

i2 is the sum of squares of the errors between the forecasted data an
the real values


you need more info? what type

--
kcka
-----------------------------------------------------------------------
kckar's Profile: http://www.excelforum.com/member.php...fo&userid=2532
View this thread: http://www.excelforum.com/showthread.php?threadid=39418

optimization
 

Look at the Excel VBA help on Solver.

--
Regards,
Tom Ogilvy

"kckar" wrote in
message ...

its kind of complex

basically i am creating a forecast model where d2:f2 alpha, beta and
delta values. (that all alter the forecast)

i2 is the sum of squares of the errors between the forecasted data and
the real values


you need more info? what type?


--
kckar
------------------------------------------------------------------------
kckar's Profile:
http://www.excelforum.com/member.php...o&userid=25322
View this thread: http://www.excelforum.com/showthread...hreadid=394184

optimization
 

It sounds to me that the tool you need is Solver... found on the mai
menu under ToolsSolver.

HTH

Bruc

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=39418