What is the proper way to create a formula for inventory subtractions RRS feed

  • Question

  • I am trying to create an inventory spreadsheet to subtract a quantity from an order from the on hand total. And the remaining hand total to stay subtracted when another order is subtracted. I tried for example, =A1-A2 on cell A3 but the total keeps changing every I insert a new order deduction on A2 (it reverts back to the previous amount.) Please help, I am trying to have the warehouse subtract the qty they are packing from the most recent on hand amount. 

    Tuesday, October 26, 2010 6:07 PM