View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bastien86 bastien86 is offline
external usenet poster
 
Posts: 6
Default Trendline Equation

Is there a way to insert the equation of my trendline into calculations in my
worksheet. The rate is always changing each passing day due to more
collected data... I wish to give a daily projection on when the certain
maximum is going to be reached, which is goign to always be changing because
of the changing trendline. Can I make reference to a data sereis trendline
ie.

y=10e^5x

x = hours

is there a way i can calculate x for a set y? and if the trendline changes,
then so does the value of x?