LINEST, LOGEST, GROWTH or TREND??

N

NlCO

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 thre
cells down and it should appear, but the numbers I get applies onl
to:

f(t) = b*c^t

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

Thanks NlC
 
Top