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.
Search JabSto ::




Custom Search