Cheers Luke

Will give it a go

Regards

Garf

"Luke M" wrote:

Look in XL help file about LINEST function. This will give you the slope and
y-itnercept of your trendline, which you can then use to calculate any x or y
value if you know the corresponding value.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Garf" wrote:

I am doing a basic spreadsheet that has a linear trendline applied, how do i
show the end value of the forecasted trendline on the spreadsheet