copy trendline equation to cells for use in other calculations

[elaine101]

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.

 

[Mike Middleton]

elaine101 -

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

- Mike

http://www.MikeMiddleton.com