Hide error values and error indicators in cells

1. Select the cells that contain the error value.
2. On the Format menu, click Conditional Formatting.

3. In the box on the left, click Formula Is.

4. In the box on the right, type =ISERROR(reference), where reference is a reference to the cell that contains the error value.

5. Click Format, and then click the Font tab.

6. Click Format.
7. In the Color box, select white.

Use the IF, ISERROR, and NA functions to do this task.

1. Select the cell that contain the error value.
2. Wrap the following formula around the formula in the cell, where old_formula is the formula that was previously in the cell.

   =IF(ISERROR(old_formula),"",old_formula)

Worksheet example

The example may be easier to understand if you copy it to a blank worksheet.

How?

Function details

IF

ISERROR

1. Click the report.
2. On the PivotTable toolbar, click PivotTable, and then click Table Options.
3. Do one or more of the following:

   Change error display    Select the For error values, show check box under Format options. In the box, type the value you want to display instead of errors. To display errors as blank cells, delete any characters in the box.

   Change empty cell display    Select the For empty cells, show check box. In the box, type the value you want to display in empty cells. To display blank cells, delete any characters in the box. To display zeros, clear the check box.

If a cell contains a formula that breaks one of the rules, a triangle appears in the top-left corner of the cell. You can prevent these indicators from being displayed.

Cell with a formula problem

1. On the Tools menu, click Options and then click the Error Checking tab.
2. Clear the Enable background error checking check box.