title: Get value from the cell above
body: <p>Is it possible in Google Spreadsheets to reach the value of the cell just above?</p>
  
  <p>Meaning: In one cell <code>A2</code> I want to display the value from the cell above, that is <code>A1</code>. Not because it is that coordinate, but because it is the cell above. I do this by simply setting the value equal to the above cell:</p>
  
  <p><img src="https://i.stack.imgur.com/Yurnp.png" alt="enter image description here"></p>
  
  <p>If I create a new row in between those two, I get this:</p>
  
  <p><img src="https://i.stack.imgur.com/y5pOZ.png" alt="enter image description here"></p>
  
  <p>As we know, no change in the values, since the reference is not relative in this way. How can I make it relative to the cell, so I always pick the cell above nomatter what is changed? I want the result to be this:</p>
  
  <p><img src="https://i.stack.imgur.com/GIVeN.png" alt="enter image description here"></p>
  
  <p>The term <em>relative</em> is <a href="http://www.gcflearnfree.org/googlespreadsheets/14.2" rel="noreferrer">wrong in the case</a> of course, but I hope you get my point. I <em>both</em> want the usual relative behavior (so I can move the cell itself and its reference will fit to the new coloumn and row) <em>as well as</em> the behavior that the reference does not point towards a specific fixed coordinate but rather a specific path from the cell itself.</p>