Thanks Chandoo. I checked your three possibilities, but none were the cause. I don't know why this was happening, but I suppose it doesn't matter now because Colin Legg fixed it for me. When I modified the formula the way he suggested, the problem was fixed. Thanks to both of you for your...
I'm a financial analyst and have been using Excel for years and consider myself reasonably proficient. I've built a simple spreadsheet for my personal use to track Budget vs Actual for a new home currently under constructon.
Here is the formula: +IF(D94=D95,"OK","CHECK AGAIN")
It simply...