need help on how to achieve a credit forward

Copper Contributor

RainbowBills_0-1643823824533.png

I need the excess amount of G4 that is over the total in G3 to be moved to G6, and so on and so fourth all the way down. I have been doing manually but I know there has to be a way to do this, but I am not that good at formulas, I know a =IF(G4>G3) would be the start but I do not know how to get it to do what I want past that.

0 Replies