Dynamically getting values from the previous cell by using formula tool

[nikhil123]

Hi,

I want to dynamically change the numbers in every next cell by using the data from the previous cell. Example mentioned below.

Kindly help me to create a formula or let me know if I can use another tool to get the desired result.

Many thanks

Name	Roll In Amount	d1	d2	Roll Out Amount
ABC				-	8,097,223,421	Current Formula from the excel file
ABC	240,000,000	10/6/2020			8,337,223,421	~+H100+D101-G101 ( Where H is the Previous value, D is the Roll in Amount from the current row and G is the Roll out amount from the current row)
ABC	3,000,000,000	10/7/2020			11,337,223,421	~H101+D102-G102
ABC			10/17/2020	283,000,000	11,054,223,421
ABC			10/17/2020	200,000	11,054,023,421
ABC			10/22/2020	1,000,000,000	10,054,023,421

[anjaliaithal]

Please check out multi-row tool

https://www.youtube.com/watch?v=5aw52R71rfU

[Qiu]

@nikhil123 

Took me sometime to understand it. Hopefully I am correct about it.