SOLVED

I need to be able to minus from one row until it goes down to 0 then move to the next row

%3CLINGO-SUB%20id%3D%22lingo-sub-2649525%22%20slang%3D%22en-US%22%3EI%20need%20to%20be%20able%20to%20minus%20from%20one%20row%20until%20it%20goes%20down%20to%200%20then%20move%20to%20the%20next%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2649525%22%20slang%3D%22en-US%22%3E%3CP%3EIm%20using%202016%20windows%20excel%2C%20I%20quickly%20sketched%20up%20a%20mockup%20so%20it%20is%20easier%20to%20visualise%20the%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20issue%20is%20I%20have%20no%20idea%20how%20to%20go%20about%20this.%20I%20need%20to%20minus%20the%20cash%20flow%20down%20into%20the%20accounts%20to%20withdraw%20from%20until%20each%20account%20hits%200.%20Once%20an%20account%20hits%200%20I%20need%20to%20move%20onto%20the%20next%20row%20and%20take%20the%20remainder%20of%20the%20amount%20out%20of%20the%20next%20row.%3C%2FP%3E%3CP%3EAnything%20will%20help%2C%20Thanks%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-08-15%20at%2010.35.07.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303318iC2994838004F0BBC%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-08-15%20at%2010.35.07.png%22%20alt%3D%22Screenshot%202021-08-15%20at%2010.35.07.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2649525%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2650285%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20to%20be%20able%20to%20minus%20from%20one%20row%20until%20it%20goes%20down%20to%200%20then%20move%20to%20the%20next%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2650285%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20a%20mockup%20and%20how%20it%20should%20be%20is%20below.%20I%20hope%20this%20helps%20to%20understand%20what%20I%20am%20trying%20to%20do.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%20add%20the%20cash%20flow%20into%20the%20account%20if%20it%20has%20any%20balance%20in%20it%2C%20if%20not%20then%20move%20onto%20the%20account%20below.%20I%20would%20want%20the%20balance%20when%20moved%20to%20the%20cell%20below%20to%20have%20not%20lost%20its%20value%20to%20be%20taken%20out%20from%20the%20other%20account.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2650319%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20to%20be%20able%20to%20minus%20from%20one%20row%20until%20it%20goes%20down%20to%200%20then%20move%20to%20the%20next%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2650319%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%22Screenshot%202021-08-15%20at%2021.08.40.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303393i9CE68F883832A875%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-08-15%20at%2021.08.40.png%22%20alt%3D%22Screenshot%202021-08-15%20at%2021.08.40.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI've%20set%20a%20bit%20of%20a%20layout%20of%20what%20I%20was%20hoping%20to%20happen%2C%20if%20that%20is%20even%20possible.%3C%2FP%3E%3CP%3EIdeally%20for%20each%20column%20it%20checks%20if%20there%20is%20a%20balance%20in%20it%2C%20if%20not%20it%20moves%20downwards%20and%20checks%20the%20other%20accounts.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20for%20any%20help%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2649659%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20to%20be%20able%20to%20minus%20from%20one%20row%20until%20it%20goes%20down%20to%200%20then%20move%20to%20the%20next%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2649659%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1128776%22%20target%3D%22_blank%22%3E%40Joshscott%3C%2FA%3E%26nbsp%3BWhy%20not%20upload%20you%20mock-up%20and%20indicate%20the%20desired%20result%20for%20the%20firs%20few%20months%20by%20just%20typing%20the%20correct%20amounts%20in%20the%20cells.%20Then%20it's%20easier%20to%20visualize%20what%20you%20want%20and%20com-up%20with%20a%20formula%20or%20other%20solution.%20Right%20now%2C%20you%20show%20a%20bunch%20of%20account%20balance%20that%20do%20not%20seem%20to%20relate%20to%20the%20cash%20flow%20amounts.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2650902%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20to%20be%20able%20to%20minus%20from%20one%20row%20until%20it%20goes%20down%20to%200%20then%20move%20to%20the%20next%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2650902%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1128776%22%20target%3D%22_blank%22%3E%40Joshscott%3C%2FA%3E%26nbsp%3BSee%20attached%20in%20the%20green%20shaded%20area.%20I%20believe%20this%20works%20as%20desired.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2651176%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20to%20be%20able%20to%20minus%20from%20one%20row%20until%20it%20goes%20down%20to%200%20then%20move%20to%20the%20next%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2651176%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%20man%2C%20honestly%20helped%20me%20so%20much%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3EI%20was%20really%20not%20sure%20if%20it%20can%20be%20done%2C%20cheers%3C%2FLINGO-BODY%3E
New Contributor

Im using 2016 windows excel, I quickly sketched up a mockup so it is easier to visualise the problem.

 

My issue is I have no idea how to go about this. I need to minus the cash flow down into the accounts to withdraw from until each account hits 0. Once an account hits 0 I need to move onto the next row and take the remainder of the amount out of the next row.

Anything will help, Thanks

Screenshot 2021-08-15 at 10.35.07.png 

 

5 Replies

@Joshscott Why not upload you mock-up and indicate the desired result for the firs few months by just typing the correct amounts in the cells. Then it's easier to visualize what you want and com-up with a formula or other solution. Right now, you show a bunch of account balance that do not seem to relate to the cash flow amounts.

@Riny_van_Eekelen 

Here is a mockup and how it should be is below. I hope this helps to understand what I am trying to do. 

 

Basically add the cash flow into the account if it has any balance in it, if not then move onto the account below. I would want the balance when moved to the cell below to have not lost its value to be taken out from the other account. 

Screenshot 2021-08-15 at 21.08.40.png

I've set a bit of a layout of what I was hoping to happen, if that is even possible.

Ideally for each column it checks if there is a balance in it, if not it moves downwards and checks the other accounts.

 

Many thanks for any help

best response confirmed by Joshscott (New Contributor)
Solution

@Joshscott See attached in the green shaded area. I believe this works as desired.

Thank you so much man, honestly helped me so much
I was really not sure if it can be done, cheers