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 | |
