Hi guys,
I'm looking for a formula on cell D23, it should be able to add the values from column D from the top cell till it reaches/ or is close to the Max capacity (cell number F23). Then after it reaches the max capacity, the exceeded amount should be added to the next cell which is D24, ...
On the other hand, on Column E which is status would like to indicate in which cell "bank name" this value has been added.
I'm looking for a formula on cell D23, it should be able to add the values from column D from the top cell till it reaches/ or is close to the Max capacity (cell number F23). Then after it reaches the max capacity, the exceeded amount should be added to the next cell which is D24, ...
On the other hand, on Column E which is status would like to indicate in which cell "bank name" this value has been added.