Troubleshooting Common Problems with Formulas

Formulas are great when they work, but a single-letter typo or a wrong reference can prevent a formula from working correctly. This section shows you how to deal with common problems with formulas, starting with solutions to the error messages you're most likely to produce.

CAUTION: This section shows you how to troubleshoot problems that Excel can identify because they prevent your calculations from working. But what can be much more dangerous are mistakes in formulas that don't cause errors but instead give the wrong results; because the formulas work correctly, Excel can't detect the errors and so raises no objections, but the values you get aren't what you intend. If having your calculations ...

Get Learn Excel 2011 for Mac now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.