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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
