How do I write a trendline constant into a cell?

[Guest]

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.

 

[Jon Peltier]

You can get this using the worksheet array function LINEST (see the help files), or
by parsing the formula using Dave Braden's code, posted here:

http://groups-beta.google.com/group..._frm/thread/edb681e63ba3bf2d/4d440d271303e0d6

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Michael R Middleton]

Hanbotkot -

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

- Mike

www.mikemiddleton.com

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