Solver will do it. Is there any way to automate Solver so that it works like
a worksheet function?

"Ralph" wrote:

I have a 6th order polynomial fit of data points. I want to find the number
that would give the maximum value of this curve. Is there a formula that
would do this without creating a large table and evaluating the table for the
Max?
(eg. derivative where slope = 0 indicates maximum)