View Single Post
  #1   Report Post  
NlCO
 
Posts: n/a
Default LINEST, LOGEST, GROWTH or TREND??


Hi all, I need to get the R2 of a formula like this

f(t) = a + b*c^t

I've tried with LINEST(Range Y,LN(Range X),,TRUE) then the array three
cells down and it should appear, but the numbers I get applies only
to:

f(t) = b*c^t

Anybody knows how to get the real value or the r2 in any other way?

Thanks NlCO


--
NlCO
------------------------------------------------------------------------
NlCO's Profile: http://www.excelforum.com/member.php...o&userid=26123
View this thread: http://www.excelforum.com/showthread...hreadid=397762