I think I'm losing my mind. I have a subtraction (Actuals - Planned) and it works for some months and not others. It's exactly the same formula, just for different months (hence different values). I checked all the references and they're pointing to the right cells. Jan/Feb don't work, rest of the year does. Copying/pasting the formula hasn't worked (in fact it yields the results of the originating cell even though the references say otherwise) and even deleting and retyping doesn't fix it. I've attached screen shots for reference. This is just subtraction... why so hard?!
J results are wrong, P is correct
Formulas view so you can see they are the same
This is the formatting on both cells which explains why one is red and the other is not.
