Negative Entry to calculate remaining inventory
Here is what I am looking to do, I am tracking inventory via a spreadsheet, I
would like to be able to put an entry on the totals cell and it will then
calculate the remaining amount. So my total inventory is 1000 and I sell
250, I can input the 250 on the Total Cell (currently 1000) and it will
subtract the total remaining giving me 750 in the totals cell. Is this
possible? Any other suggestions on what I might do here? Thanks a lot in
advance.
|