hOW DO i SUBTRACT COLUMNS IN EXCEL?

[Guest]

Please help me. I am very new to Excel. I am trying to subtract one column
from the next. I do not know where to put the formula; or even what the
formula would be.? Signed Extremely Frustrated.

 

[gjcase]

To subtract Col B from Col C, assuming you have data in hte first 1
rows:

Enter =A1-B1 in col C1. Then copy C1 down thru C10. Excel will adjus
the formula as you copy down. To copy, select C1 and hit Crtl-C , the
highlight c2:c10 and hit Ctrl-V. Alternatively, grab the lower R
corner of C1 & drag it down thru C10.

Result will be that each cell in Col C is the difference of th
corresponding cells in Cols A & B.

You can try cruising thru the Excel "Help" contents for help o
specific functions.

---GJ