need help on how to achieve a credit forward

%3CLINGO-SUB%20id%3D%22lingo-sub-3106617%22%20slang%3D%22en-US%22%3Eneed%20help%20on%20how%20to%20achieve%20a%20credit%20forward%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3106617%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22RainbowBills_0-1643823824533.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F344688i063C5AB5BFB13145%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22RainbowBills_0-1643823824533.png%22%20alt%3D%22RainbowBills_0-1643823824533.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20need%20the%20excess%20amount%20of%20G4%20that%20is%20over%20the%20total%20in%20G3%20to%20be%20moved%20to%20G6%2C%20and%20so%20on%20and%20so%20fourth%20all%20the%20way%20down.%20I%20have%20been%20doing%20manually%20but%20I%20know%20there%20has%20to%20be%20a%20way%20to%20do%20this%2C%20but%20I%20am%20not%20that%20good%20at%20formulas%2C%20I%20know%20a%20%3DIF(G4%26gt%3BG3)%20would%20be%20the%20start%20but%20I%20do%20not%20know%20how%20to%20get%20it%20to%20do%20what%20I%20want%20past%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3106617%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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