I see #DIV/0! instead of content in some cells

Cause: The formula contains a reference to a blank cell or to a cell that contains zero as a divisor.

Solution:    Find and change the blank cell or cell that contains zero.

1. Select the cell that has the error.

2. Click the button that appears next to the #DIV/0! error, and then click Trace Error or Trace Empty Cell.

   A tracer arrow shows the cell that is causing the #DIV/0! error.

3. Do one of the following:

To	Do this
Use a different cell reference for the divisor	In the Formula Bar, edit the formula.
Change the cell contents	In the cell that is causing the #DIV/0! error, type a number other than zero.

Note: If the operand references a blank cell, Excel interprets the blank cell as zero.

Solution:    Enter the value #N/A into the cell referenced as the divisor, which will change the result of the formula to #N/A from #DIV/0! to denote that the divisor value is not available.

1. Select the cell that has the error.

2. Click the button that appears next to the #DIV/0! error, and then click Trace Error.

   A tracer arrow shows the cell that is causing the #DIV/0! error.

3. In the cell that is causing the #DIV/0! error, type #N/A.

   Note: If the operand references a blank cell, Excel interprets the blank cell as zero.

Solution:    Prevent the error value from displaying by using the IF function.

For example, if the formula that causes #DIV/0! to appear is =A5/B5, use =IF(B5=0, "", A5/B5) instead. The two quotation marks represent an empty text string, and the error value displays as a blank cell.