O'Reilly logo

Microsoft® Office® Professional 2013 Plain & Simple by Katherine Murray

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 formulas

Excel 2013 includes a number of tools to help you troubleshoot the formulas in your worksheet. If things aren’t working out properly or you’re questioning the accuracy of a formula (or Excel displays an error indicator, alerting you to a problem), you can use these tools to find the problem and correct it.

Check for formula errors

  1. Click the Formulas tab.

  2. In the Formula Auditing group, click the Error Checking tool.

    The Error Checking dialog box opens.

  3. Use the controls in the Error Checking dialog box to change the formula or ignore the error.

  4. Click Previous or Next to view the preceding or ensuing error that Excel has found in the worksheet.

  5. Click the Close box to close the Error Checking dialog box and return ...

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