Forum Discussion
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
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.