A
Abanky
right now i have 4 columns, Column A goes from 0 to 120 (i can only sho
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 th
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 pu
in my n (as in g6) and i get the value associated with it for eac
calculation... I can do it for column c and columnd, but i can't figur
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 th
={PRODUCT(1-B2:INDIRECT("B"&($G$6+1)))} from n to 122
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 th
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 pu
in my n (as in g6) and i get the value associated with it for eac
calculation... I can do it for column c and columnd, but i can't figur
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 th
={PRODUCT(1-B2:INDIRECT("B"&($G$6+1)))} from n to 122