• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How do you calculate an exponential formula ?

I have been trying to calculate an exponential formula by have no idea how this works

I know the exponential formula is something along the lines of y = exp(linest(ln)) * e ^ linest(ln) * x

But I can't seem to get this to work (the yellow highlighted cells) - would appreciate if someone could advise where I'm going wrong ?
 

Attachments

  • exponential_trend.xlsx
    14.6 KB · Views: 4
It should be... Copy down.
=$R$3*EXP($P$3*A3)

e is constant (approx 2.71828182845904, base of the natural log) = EXP(1)

EXP(Number) returns e raised to the power of number.
Meaning EXP(1)^($P$3*A3)=EXP($P$3*A3)

And EXP should be resolved before multiplication.
 
Last edited:
Back
Top