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.

Bemærk: 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.

    Bemærk: 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.

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!

×