Microsoft Office Tutorials and References
In Depth Information
Making an Error Behave the Way You Want
Cell H7 has the tried-and-true way to make the error not look like an error.
Using the IsError function nested inside an If function takes care of the
error’s appearance, as seen in cell H7 (which refers to cell F7). Cell H8
achieves the same result with the new IfError function. Cells J7 and J8,
respectively, show the formulas that are in cells H7 and H8.
✓ In cell H7 is =IF(ISERROR(F7),0,F7+3)
✓ In cell H8 is =IFERROR(F7+3,0)
The main distinction is that IfError, as a single function, does what used
to take two functions. I don’t know how many times the “keep it simple”
approach has been bantered around, but what the heck — aren’t we all for
making our work easier? With IfError, the first argument is being tested. If the
test makes sense, Excel goes with it. Otherwise, the second argument is used.
IfError can return a message. For example, consider this: