title: formula to subtract pairs of cells - excel
body: <p>I have a spreadsheet which I want to: <code>E2=C3-C2</code>, then <code>E3=C5-C4</code>, <code>E4=C7-C6</code> etc for lots of cells:</p>
  <p><a href="https://i.stack.imgur.com/YaOU8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YaOU8.png" alt="enter image description here" /></a></p>
  <p>So I am looking for a formula which I can drag down which minuses values in pairs rather than consecutively.</p>
  <p>I tried SUM(OFFSET) but only added values, not minus.</p>
  <p>Any help greatly appreciated!</p>