Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 Last edited by Abanky : May 30th 12 at 03:05 PM Reason: trying to clean up format |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How create a formula series with series inside | Excel Worksheet Functions | |||
Setting Up a Series of Formulas | Excel Worksheet Functions | |||
Graph data series formulas: How to global-change all sheet reference to formula | Excel Discussion (Misc queries) | |||
fill series formulas | Excel Discussion (Misc queries) | |||
Repeat series of formulas | Excel Programming |