Am I the only person that gets this problem? Sometimes I will enter a
formula in a cell and after I hit return it won't give the result of
the formula but will only display the formula. I will go to the cell
right next to it and do the exact same thing and it will then work
normally.

This drives me nuts.