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]

						let us assume this is the equation found
		x	y			y=x^3
		1	1
		2	7
		3	28			merely feed in the formula
		4	62			to future x values
		5	131
		6
		7
		8
		9

<colgroup><col width="64" span="11" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[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