thats a good site, however I do not have an inital value. i can't get the
value of B in the equation y=Be^Ax to equal the B in the trendline. but i
can get A with with the logest formula. Any tips on getting the value of B?
"Bernard Liengme" wrote:
See
http://www.stfx.ca/people/bliengme/E...&%20LOGEST.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"bastien86" wrote in message
...
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?