Forum Discussion

jordanhooz's avatar
jordanhooz
Copper Contributor
Apr 07, 2020

Subtraction excel

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
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 07, 2020

jordanhooz 

In B1 it could be

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

and drag it down

Resources