I've created an inventory spreadsheet.
A10)Item B1)Quantity Sold C1)Price per item x B1 D1)Original Inventory E1)
D1-B1

I'm sure it's simple, but...How can I keep E1 accurate? If I save, then
zero out B1 for the next transaction E1 goes back to =D1

Thanks.