How do I aucto subtract?

[wildtreemommy]

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?

 

[Alan]

In D1, =B1-C1 and drag it down,
Regards,
Alan.

 

[Chris Bode]

put following formula in D1
=B1-C1
now select D1 and scroll it down to apply the formula to cells belo
D1

Chris

 

[Fred Smith]

To drag down a formula, click (and hold) the fill handle of the cell's box.
The fill handle is the small black square on the bottom right of the box.
While holding down the left mouse button, drag the box down. The box will
expand to show your selection. When you release the mouse button, Excel will
fill the selected cells with your formula, with the addresses adjusted
appropriately.

Regards,
Fred.