Excel Tip Tuesday: Hide Those Formula Errors

Posted by Lisa on September 4, 2018 at 9:30 AM

Excel IconExcel'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:

Excel Tips - IFERROR1

A slight modification to the formula using the IFERROR function can hide that error (and make you look way smarter):

Excel Tips - IFERROR2

For help with the formula click the fx in the formula bar.

Excel Tips - IFERROR5

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.

Excel Tips - IFERROR3

Here are a couple more examples of other common uses for the IFERROR function:

Excel Tips - IFERROR4

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.

Topics: Excel

Don't Miss a Thing!

Subscribe to our blog

Subscribe to our blog

    Recent Posts

    Posts by Topic

    see all