Min value of a function
Min value of a function
(OP)
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.





RE: Min value of a function
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
Steam Engine enthusiasts: www.essexsteam.co.uk
RE: Min value of a function
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.