Need Help with Formula!

[Captkraken33]

So I'm not sure if this can be done or not but what I'm trying to do is take a value from one cell and subtract from it until it reaches zero and then start subtracting from another cell. So say I have 2 boxes that hold 50 pounds in B1 and C1. I then In column A have different items varying in weight. I want to check and see if the item in A1 will fit in box 1 in B1 and if it will then deduct the items weight from the box. Then continue going down the list in A1 deducting items until B1 reaches 0. If the item wont fit in B1 then I want it to check and see if it can be deducted from C1 and if it can then do it there. Once B1 is 0 I want C1 to pick up where B1 left off in column A until all items in Column A are accounted for. I hope that makes sense!

Thanks ahead of time!

 

[vw412]

I can send you my workbook file if it would help to see what im doing better

That would be great.

 

[Captkraken33]

I appreciate it! Here is a link to the game explanation page. Maybe you can look at that and kind of see what im trying to do! Mech Lab - MWO Wiki

 

[Fluff]

I can send you my workbook file if it would help to see what im doing better

To do that you would need to upload the file to a share site such as OneDrvie, GoogleDrive. Then mark for sharing & post the link you get to the thread.