Exponential Trendline

[Brit_Nelson]

Hi Guys,

Great site. I'm having a massive issue with the exponential trendline and have been stuck all day so hoping someone can help me.

I have months Jan-11 to Dec-20 in a row (b7 to DQ7), with some actual volumes in the row below until Oct-14 (b8 to au8). I have graphed these and added an exponential trendline and displayed the equation. I want to use this equation to project the volumes for Nov-14 onwards starting in cell av9 to dq9. The equation displayed is y=3E+32e -0.002x (The -0.002x) is slightly smaller and higher up as if it means to the power of possibly.

Does anyone know how I would stick this equation into cell av9 and be able to drag it across so that the remaining months are projected?

Thanks in advance for any advice given.

 

[oldbrewer]

[TABLE="width: 704"]
<colgroup><col width="64" span="11" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]let us assume this is the equation found[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="class: xl24"]x[/TD]
[TD="class: xl24"]y[/TD]
[TD][/TD]
[TD][/TD]
[TD]y=x^3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="class: xl24"]1[/TD]
[TD="class: xl24"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="class: xl24"]2[/TD]
[TD="class: xl24"]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="class: xl24"]3[/TD]
[TD="class: xl24"]28[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]merely feed in the formula[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="class: xl24"]4[/TD]
[TD="class: xl24"]62[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]to future x values[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="class: xl24"]5[/TD]
[TD="class: xl24"]131[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="class: xl24"]6[/TD]
[TD="class: xl24"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="class: xl24"]7[/TD]
[TD="class: xl24"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="class: xl24"]8[/TD]
[TD="class: xl24"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="class: xl24"]9[/TD]
[TD="class: xl24"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[oldbrewer]

or E = 2.718 so is your power equation y = 3 * 2.718 + 32*(2.718^(-0.002 * X)

if so use this for future predictions

 

[Brit_Nelson]

It doesnt really bring back the number I would expect. Is big E not to the power of ten? Or times to the power of ten, I forget which?

 

[RoryA]

Have you tried just using the GROWTH function?

 

[Brit_Nelson]

GROWTH formula worked perfect. Thanks all for your advice