Rob,

Here's a thought.

Go in to where you added the trendline. Set it to "show equation on
chart". Set the equation up as a formula in your spreadsheet and input
the necessary information (i.e. the x value). It will give you an exact
value based on the equation used to generate the trendline.


--
random1970
------------------------------------------------------------------------
random1970's Profile: http://www.excelforum.com/member.php...o&userid=32112
View this thread: http://www.excelforum.com/showthread...hreadid=519086