Unless you are dealing with some rather extreme functions, the process
outline by Bernard Liengme in
http://www.stfx.ca/people/bliengme/E...Polynomial.htm will do the
job.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hi All...........

I'm not much into higher math, or charting myself, but one of my users has
drawn a Scatter Chart and added a third order polynomial trendline to try to
pick up the missing value on the high end of his data...........Excel draws
the trendline on the chart just fine, but does not give a tickmark for the
corresponding value in question, rather gives just a formula in a Label-box
which when calculated by hand will give the desired value...........problem
is, my user wants Excel to calculate the value for him.........I have
managed this by Cntrl-C copying the formula out of the label box and
breaking it apart and doing the math, but this seems like the long way
around.........I can't "select" the formula out of the label-box...........

Question is, is there any way for Excel to do this calculation, or any way I
can "grab" that formula, maybe with VBA so as to do the calcs automatically?

TIA,
Vaya con Dios,
Chuck, CABGx3