• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Checking for Errors

Since the Excel worksheet displays the results of a formula calculation, it’s sometimes difficult to tell if there is an error in your formula which could be giving you erroneous values. Excel includes an Error Checking feature which reviews the worksheet formulas for potential errors then describes and offers to help correct the problem. Here are a few of the formula errors Excel tries to note with the Error Checking feature:

  • Formulas that result in an error message such as the divide by zero error.

  • References used in a formula that are not consistent with those in the adjacent formulas

  • Formulas that omit cells in an area

  • Unlocked cells containing formulas in a protected worksheet

  • Formulas referencing empty cells


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint