title: Excel formula is doing the calculation, but still displaying the first answer in the cell
body: <p>Pulling my hair out over this. When I use the drag button on my selection to copy the formula down relatively, it will correctly alter the formula to go one row down, but will still display the wrong answer in the cell. I'm unable to post an image due to my low rep(I'm a long time lurker, new poster), but please find a link to the image below:</p>
  
  <p><a href="http://i.stack.imgur.com/6gR4y.png" rel="nofollow">http://i.stack.imgur.com/6gR4y.png</a></p>
  
  <p>The formula for that cell is:</p>
  
  <pre><code>=MROUND(B21,"1:00")
  </code></pre>
  
  <p>Which is basically rounding the hour to the nearest hour.</p>
  
  <p>However, as you can see, the cell shows the answer '10:00' which is wrong, it should be '09:00'.</p>
  
  <p>Now the real part that throws me is, if I click in the formula box at the top as if I was going to edit the formula, and then press enter to leave the box the cell then corrects itself to what it should be! It's as if when I drag the formula down, it puts the formula in the box but doesn't actually calculate it until it thinks I'm changing it.</p>
  
  <p>Any help would be greatly appreciated. Sorry if this is a confusing post :)</p>