• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 5. Working with Formulas and Functions > Recognizing the #REF! Error

Recognizing the #REF! Error

In the cell you want to use as the resultant cell, type the formula you want to use in your calculation. For example, type =SUM(B3+C3+D3+E3) and press Enter.

Right-click one of the columns that contains a cell referenced in the formula you just typed (here, column E), and choose Delete from the shortcut menu that appears.

In this case, the #REF! error appears because the values in cells referenced in column E are no longer available in the formula. Click the Undo button to correct it.

The error disappears because the formula values are restored.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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