Subtraction excel

Copper Contributor

Hi I am trying to create a formula on excel where if I drag down this would happen.  e.g. cell B1 =A2-A1 then in cell B2 = A4-A3 and then in B3 = A6-A4 etc thank you

2 Replies

@jordanhooz 

 

Since you gave us an image to work with, I'll give you one back. I think what you're looking for can be managed by the INDIRECT function. Here's some of the Help text on that function....and it's a fun one to play with. You can write a formula within your formula that increments the cell reference, as you're tring to do. Come back if you're not able to make it work in your situation.

mathetes_0-1586271864768.png

 

@jordanhooz 

In B1 it could be

=INDEX(A:A,ROW()*2)-INDEX(A:A,ROW()*2-1)

and drag it down