Iterative loop

[SuhailPasha07]

Hi, I'm trying to execute an iterative logic for the below template

Input:

Open balance	New billing	Close balance
0	0	100
	50
	70
	80
	90

expected Output:

Open balance	New billing	Close balance
0	0	100
100	50	150
150	70	220
220	80	300
300	-60	240

Here I'm trying to create an iterative loop where the close balance in 1st row is the new open balance in 2nd row and the close balance for the second row is an addition of open balance + New billing in the second row and the loop should repeat so on.. 

Any help would be appreciated.

Regards,

Suhail

[LordNeilLord · Accepted solution]

Hey @SuhailPasha07 

You should be able to achieve this with Multi-Row formula:

[SuhailPasha07]

Thanks Neil !!