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.