Min value of a function

[steveyeung]

I have a problem about using VBA for Excel to search for a minimum value for a function within a given range of independent variables. (i.e. Min of f(x) and x1 < x < x2). The major tricky point is that it is difficult to do differentiation.

 

[johnwm]

Have a look at the Solver Add-In

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting

Steam Engine enthusiasts:

http://www.essexsteam.co.uk

 

[score33]

just a one variable problem?

can you not just use newton's method? I believe this way you just evaluate the function instead of trying to compute the equation for the derivative.

or maybe I don't understand what you are trying to do.