Knockoutpie
Board Regular
- Joined
- Sep 10, 2018
- Messages
- 116
- Office Version
- 365
- Platform
- Windows
It's difficult to describe, but could be considered something like a first in first out calculator.
There must be an easier way to do this than manual subtraction.
For this example the total inventory is 7500, I Would like to find how much was under 25, and if the total isn't met then move to next column under 10, etc using the next cell until the total inventory is met.
Example
<tbody>
</tbody>
Final Result
<tbody>
</tbody>
There must be an easier way to do this than manual subtraction.
For this example the total inventory is 7500, I Would like to find how much was under 25, and if the total isn't met then move to next column under 10, etc using the next cell until the total inventory is met.
Example
Item# | Total Inventory | 25 | 10 | 5 | 0 |
Part Example | 7500 | 7150 | 1800 | 7600 | 32950 |
<tbody>
</tbody>
Final Result
Item# | Total Inventory | 25 | 10 | 5 | 0 |
Part Example | 7500 | 7150 | 350 | 0 | 0 |
<tbody>
</tbody>