Need Help with Formula!

Captkraken33

New Member
Joined
Apr 16, 2021
Messages
7
Office Version
  1. 365
Platform
  1. Windows
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!
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
59,887
Office Version
  1. 365
Platform
  1. Windows
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.
 

Forum statistics

Threads
1,136,275
Messages
5,674,783
Members
419,524
Latest member
helensesc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top