How do I aucto subtract?

  • Thread starter Thread starter wildtreemommy
  • Start date Start date
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?
 
put following formula in D1
=B1-C1
now select D1 and scroll it down to apply the formula to cells belo
D1

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to add or subtract a range of cells 2
Excel Subtracting multiple columns from another column 3
Add/Subtract columns from tab to tab in same file 3
subtraction 2
Formula assistance with subtracting percentages 2
Column sum incorrect upon subtracting 6
Running Balance in the same cell... 2
Subtracting minutes in an +IF formula 13

Back
Top