How do I aucto subtract?

W

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?
 
C

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
 
F

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.
 
Top