series of formulas to get to one formula
 

right now i have 4 columns, Column A goes from 0 to 120 (i can only show so many values with this add on), Column B are my values at each age, Column C is my first formula, C3 = (1-b2)*c2, C4 =(1-b3)*C3 and so on. Column D is my next formula it is D3 = (1.0419^-A3)*c3. Column E is the sum of all D values in the row and below, so E9=sum(D9:d122)

what i'm looking to do is get rid of columns c,d,e and have where i put in my n (as in g6) and i get the value associated with it for each calculation... I can do it for column c and columnd, but i can't figure out how to do it in one calculation for column E.

So for A4 (G7) I got out of using Column D by using this function.

=+SERIESSUM(1/1.0419,20,1,C22:$C$122)... how do i incorporate the ={PRODUCT(1-B2:INDIRECT("B"&($G$6+1)))} from n to 122?

A1 A2 A3 A4
0 0.000000 1 1 23.8876798
1 0.000358 1 0.959785008 22.8876798
2 0.000237 0.999642 0.920857477 21.92789479
3 0.000188 0.999405085 0.883615734 21.00703732
4 0.000144 0.999217197 0.847921696 20.12342158 N= 20
5 0.000131 0.999073309 0.813705341 19.27549989 A2 0.9971568
6 0.000124 0.998942431 0.780879879 18.46179454 A3 0.43877583
7 0.000118 0.998818562 0.749383866 17.68091467 A4 =sum(D67:$d$122)
8 0.000108 0.998700701 0.719162528 16.9315308 9.98022669
9 0.000104 0.998592842 0.690166867 16.21236827
10 0.000104 0.998488988 0.662342921 15.5222014
11 0.000108 0.998385145 0.635640693 14.85985848
12 0.000112 0.99827732 0.610012519 14.22421779
13 0.000117 0.998165513 0.585415297 13.61420527
14 0.000128 0.998048727 0.561807086 13.02878998
15 0.000138 0.997920977 0.539144999 12.46698289
16 0.000146 0.997783264 0.517391878 11.92783789
17 0.000156 0.997637587 0.496512466 11.41044601
18 0.000161 0.997481956 0.47647088 10.91393355
19 0.000165 0.997321361 0.457235981 10.43746267
20 0.000168 0.997156803 0.43877583 9.980226685