I have to use only 3 cells to get a balance inventory calculator.
Let's say A1 is for initial inventory amount, C1 for total inventory balance until it show 0, and cell B1 to input every time a new quantity is used from cell A1.
C1 should show the new balance when B1 is input with the new quantity used any given day (day data is not input)
I can not use more rows nor more cells because the are filled with other data.
Let's say A1 is for initial inventory amount, C1 for total inventory balance until it show 0, and cell B1 to input every time a new quantity is used from cell A1.
C1 should show the new balance when B1 is input with the new quantity used any given day (day data is not input)
I can not use more rows nor more cells because the are filled with other data.