Hello Excel Forums Community,

Info:
So I am making a inventory spreadsheet combined with a point of sales like "interface" Where the inventory changes by subtracting the amount sold from the inventory in stock. What I am having trouble with is for every new customer the sales part needs to be blank and so far I have a formula that subtracts the inventory in stock with what is being sold, but when the sold "number" is reset to 0 the inventory stock goes back to the original number.

So one Column is sales another is inventory, the inventory formula is =IF(D38>0,5-D38,5) (not the final formula)

Mainly: Is there a way to make it so that the number inputted to the sales changes the inventory in stock and would keep it permanent while keeping the formula as well?

Thanks!