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

Fixing the #DIV/0! Error

In the cell you want to use as the resultant cell, type a formula to obtain an average, for example, type =SUM(B7/B6) in cell B9 and press Enter.

If one of the cells in your worksheet now contains the #DIV/0! error, locate the empty cell referenced by the formula (in this case, cell B6).

Click on the resultant cell (here, B9), press F2 on the keyboard, and retype the formula to omit the empty cell—in this case, =(B7/B8)—and press Enter.

The error disappears because it is no longer trying to divide a number by an empty cell.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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