Hanbotkot -

If it's a simple linear fit, you can use the INTERCEPT and SLOPE worksheet
functions.

- Mike

www.mikemiddleton.com

++++++++++++++++++++++++

"Hanbotkot" wrote in message
...
Trendline equation constants.

A trendline has been drawn on a chart and an acceptable equation has been
obtained. The constants in this equation must be used in other formulas.

How are these constants written into cells that can be used in formulas?

This is needed when the data producing a trendline, can change and thus
have
an effect through the page.