I'm trying to create a spreadsheet that calculates inventory with a column
for initial inventory), total inventory used, Inventory remaining, and a
column where you add in the quantity used for the last order and it
automatically deducts the quantity used from the balance. I'm running into a
problem where the number that I enter in the 'quantity used' column remains
and when I make other changes in the same row, it deducts the quantity used
an additional time. If I could get the value that I enter to go to zero, or
the cell to clear after I enter a value, my problem would be solved.