Microsoft Office Tutorials and References

In Depth Information

**Using the ISERROR function**

By the way, you can put anything you like as the second argument for the IFERROR function. (It

doesn’t have to be an empty string.) For example, you can make it a cell reference.

Figure 30-2:
Using an IFERROR function to hide error values.

The IFERROR function was introduced in Excel 2007, so it doesn’t work with earlier

versions of Excel. If you plan to share your workbook with people who use Excel 2003 or

earlier, you’ll need to use the ISERROR function — described next.

Note

Using the ISERROR function

The ISERROR function is used with an IF function. For the example presented earlier, use this formula

in cell D1:

=IF(ISERROR(B2/C2),””,B2/C2)

The ISERROR function returns TRUE if its argument evaluates to an error. In such a case, the IF

function returns an empty string. Otherwise, the IF function returns the calculated value.

This method of avoiding an error display is a bit more complicated, and it’s also less efficient because

the formula is actually evaluated two times if it doesn’t return an error. Therefore, unless you require

compatibility with Excel 2003 or earlier versions, you should use the IFERROR functions.