simple subtraction

  • Thread starter Thread starter nikpleep
  • Start date Start date
N

nikpleep

Hi All,

I need help subtracting values in rows from each other.

My data looks like this
Values Difference
242
242.2 .2
256 ...???
267.4
...

I have 289 values that I would like to subtract from each other. I know the
basic =C3-C2, but is there a formula that will do it all at once.

Thanks :]
 
Hi nikleep,

Your =C3-C2 should work fine. Just put it in the first cell you need it,
which, from the example you gave would be D3, then hover your mouse
over the bottom right corner of D3, when the cursor changes to a little
cross
click and drag down to the end of your data, the cell references will
update as you drag.

If you need to drag it past the end of your data to allow for further input
in column C then use =IF(C3="","",C3-C2)

HTH
Martin
 
Back
Top