How do I aucto subtract?
 

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?

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?

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

Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

How do I aucto subtract?
 

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.

"Alan" wrote in message
...
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?