View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Alan Alan is offline
external usenet poster
 
Posts: 492
Default How do I aucto subtract?

In D1, =B1-C1 and drag it down,
Regards,
Alan.
"wildtreemommy" wrote in message
...
I am putting together an inventory spreadsheet and would like it to auto
subtract. I have A as Porduct, B is On Hand, C is # sold, and D should be
B
MINUS C. How can I get D to be an auto subtract?