copy trendline equation to cells for use in other calculations
 

I need to use the trendline equation (eg y=mx+c) to solve x for other values
of y. I want t do this having set up a template in which m and c are placed
in specific cells, and not by copying the parameters manually.

copy trendline equation to cells for use in other calculations
 

elaine101 -

One way is to use the worksheet functions INTERCEPT and SLOPE.

- Mike

http://www.MikeMiddleton.com



"elaine101" wrote in message
...
I need to use the trendline equation (eg y=mx+c) to solve x for other
values
of y. I want t do this having set up a template in which m and c are
placed
in specific cells, and not by copying the parameters manually.