Hi,
I appreciate some help in creating cumulative return column using multi-row formula. I added the Excel formual which I use to generate the value in the third column
thank you
A | B | |
-0.080059 | 100 | |
-0.099113 | 99.90089 | =B2*(1+A3/100) |
-0.327131 | 99.57408 | =B3*(1+A4/100) |
-0.190854 | 99.38404 | =B4*(1+A5/100) |
Solved! Go to Solution.
How about:
[Row-1:B]*(1+[A]/100)
You can change the option for "Values for Rows that don't Exist" to NULL if you would like a Null value instead of a zero value when there is no prior record.