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?