Bill Jelen's GROWTH function video

[DRSteele]

I messed around and came up with some alternative methods to this very interesting video, includinga method for pre-MS365.

Bill's vid:

The cells in column H are just the number 1-70.

MrExcel posts18.xlsx
	B	C	D	E	F	G	H	I
6	MS365						Ye Olde Skuul Methode
7
8	Goal	600,000		Slope	0.040		Slope	0.04033
9	Weeks	10		Intercept	1498.311		Intercept	1498.311
10	Days	70
11
12		600,000			600,000			600,000
13	Day	Value		Day	Value		Day	Value
14	1	1,560		1	1560		1	1560
15	2	1,624		2	1624		2	1624
16	3	1,691		3	1691		3	1691
17	4	1,761		4	1761		4	1761
18	5	1,833		5	1833		5	1833
19	6	1,909		6	1909		6	1909
20	7	1,987		7	1987		7	1987
21	8	2,069		8	2069		8	2069
22	9	2,154		9	2154		9	2154
23	10	2,243		10	2243		10	2243
Sheet34

Cell Formulas
Range	Formula
F8	F8	=INDEX(LINEST(LN(B14#)),1)
F9	F9	=C8/SUM(EXP(F8*B14#))
I8	I8	=INDEX(LINEST(LN(H14:H83)),1)
I9	I9	=C8/SUM(EXP(F8*H14:H83))
C10	C10	=C9*7
C12,F12	C12	=SUM(C14#)
I12	I12	=SUM(I14:I83)
B14:B83	B14	=SEQUENCE(C10)
C14:C83	C14	=C8/SUM(GROWTH(B14#))*GROWTH(B14#)
E14:E83	E14	=SEQUENCE(C10)
F14:F83	F14	=F9*EXP(F8*B14#)
I14:I23	I14	=$F$9*EXP($F$8*H14)
Dynamic array formulas.