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:
https://i.sstatic.net/6gR4y.png
The formula for that cell is:
=MROUND(B21,"1:00")
Which is basically rounding the hour to the nearest hour.
However, as you can see, the cell shows the answer '10:00' which is wrong, it should be '09:00'.
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.
Any help would be greatly appreciated. Sorry if this is a confusing post :)
The answer was given as a response to my post by DataSmarter.
https://i.sstatic.net/eOiJx.png
Clicking this 'Calculation Options' button given on the 'Formulas' tab, and selecting the 'Automatic' option fixed this issue.
Thanks for your help, everybody!
