Need to generate rows based on a condition

[Sameer_Kanade8810]

Hi All,
I have a data set below as a sample.

DATE  Value              Begin Value   End Value

 1/1          0.0008             211.200        (1+[Value]*[Begin Value]   

 1/2          0.0008                ?                 (1+[Value]*[Begin Value]

My 1/2 Begin value should nothing but the End value of 1/1

How do i get the begin value .
Also note begin value will be derived from another source but it should only be updated to the first row of begin value.
Any help on this will be highly appreciated.

[geraldo]

@Sameer_Kanade8810 

I'm sorry, but with these data that you put, I did not understand your objective.

if you could explain in two more lines it would make my understanding easi

[lynnesonney]

Hi @Sameer_Kanade8810 !

This looks to me like an interest calculation. The simplest way I could come up with is attached. I generate rows for the dates first, then calculated the beginning balance based on the previous row. From there I can calculated the "END" balance straight across. 

Let me know if this helps!

[nagakavyasri · Accepted solution]

Use Muti-Row formula tool

[Sameer_Kanade8810]

Thank you all for the help.