⟩ I find that sometimes my formulas do not get fully calculated. This often happens when I use custom functions created with Visual Basic?
Microsoft has acknowledged some problems with the Excel calculation engine. In order to be assured that all of your formulas have been calculated, press Ctrl-Alt-F9 to force a complete recalculation.