Excel's IFERROR function returns a custom specified result when a formula generates an error, and it presents a standard result when no error is detected. IFERROR is an easy way to hide formula errors without using more complicated and nested IF statements (blech!).
Use the IFERROR function to hide errors produced by other formulas or functions. IFERROR checks for the following errors (you've seen these all too often, right?): #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.
Here’s an example of the error #DIV/0! on an Excel report:
A slight modification to the formula using the IFERROR function can hide that error (and make you look way smarter):
For help with the formula click the fx in the formula bar.
Doing so will bring up the Function Arguments dialog box, in which you can view what is happening with the error, along with the results.
Here are a couple more examples of other common uses for the IFERROR function:
Now those ugly errors don't have to make your reports less pretty than they should be.
Leave us a comment and let readers know what Excel tips you use on a daily basis.