Formula anomaly

Originally Posted by Mulpuzzle

So now that some of you have confirmed this peculiar anomaly where do we go from here? Is it time to tell Microsoft "sorry guys there's a fault in Excel. It's integrity is fatally undermined."?

Yep - looks like it! What do you think we should do? I mean, there is nothing wrong per se with the formulae you are using, so use one that currently gives the answers you need.