O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required