Subtracting Columns

  • Thread starter Thread starter JAG
  • Start date Start date
J

JAG

Urgent ~ What is the fastest way to subtract two columns at one tim
without typing in the formula for each entry.

Example: Column B - Column C = Column D

Thank Yo
 
Jag

in cell D1 (or D2, depending on where the data starts) put the formula
=B1-C1. Then drag down the column. The formula will adjust for each row.

Regards

Trevor
 
Hi
if you want to subtract row by row (e.g. D1 = B1-C1) try the following
- enter =B1-C1 in cell D1
- copy/drag this down
- you may also try the following. Select D1 and double click on the
lower right corner of this selection. This will fill the formula for
all rows

Frank
 
Back
Top