Depleting one cell until zero with excess to be subtracted from next designated cell

[hassingerl]

I have two cells at the top of the sheet that have different values ie(A1 & B2). Next I have a column of all different values ie(D1:D5) that need to be subtracted from A1 until A1 reaches zero. The remaining if any need to subtracted from B2.

[FDibbins]

Hi hassinggerl and welcome to the forum

If you already have a sample workbook, please upload that, and no a picture or pdf file.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[hassingerl]

I'm looking for a formula that can be copied down through the columns titled bucket 1 & 2.

[FDibbins]

thanks :0

in E6, copied down use this...
=IF(E5-C5<0,0,E5-C5)

in H7, copied down, use this...
=IF(H6-E7-C7<0,0,IF(E7>C7,H6,H6-E7-C7))

[dredwolf]

In E6:
=IF(AND(ISNUMBER(E5),E5>0),IF(E5-C5<0,"",E5-C5),"")
Copied down
In H6:
=IF(AND(E6>0,E6-C6<0),I5-ABS(E6-C6),IF(AND(H5<H5,H5>0),IF(H5-C6<0,"",H5-C6),IF(AND(ISNUMBER(H5),HI5>0),H5,"")))
copied down

Hope this helps

[dredwolf]

ignore last post by me...made some copy paste errors...sorry

[dredwolf]

In E6:
=IF(ISNUMBER(E5),IF(E5-C5<0,"",E5-C5),"")
Drag Down
In H6:
=IF(ISNUMBER(E6),IF(E6-C6<0,H5-ABS(E6-C6),H5),IF(ISNUMBER(H5),IF(H5-C6<0,"",H5-C6),""))
Drag down

While fixing the transposition errors I noticed some easier ways to do same thing, that's why it took so long to get back

Hope THIS helps