What does it do?

It returns a value that you set if a formula has an error

Formula breakdown:

=IFERROR(Value,Value if Error)

What it means:

=IFERROR(The Formula,What do you want to show if The Formula has an error?)

If you have a calculation that results in an error like, #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, then you can clean it up by using the IFERROR function which allows you to replace the error it with a 0 or a blank cell.


We want to get the average sale of each record. However we need to handle division by zero errors gracefully.

STEP 1: We need to enter the IFERROR function in a blank cell:


IfError formula


STEP 2: The IFERROR arguments:


What is the formula?

We need to enter the formula first to calculate the average sale.


IfError formula


What value should be displayed if there is an error in the formula?

We want “0” to be displayed if there is an error

=IFERROR(D15/E15, 0)

IfError formula

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

IfError formula

You now have all of results!

How to Use the IfError Formula in Excel



How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel


If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Highlight All Excel Formula Cells   Whenever you are auditing an Excel worksheet and need to know where all the formulas are located, a great way is to highlight the formula cells in a distinctive color.  This is how it is done: STEP 1: Select all the cells in your Excel worksheet by clicking on the to...
Advanced SUMPRODUCT Function: Conditional Sum Another great way that you can use the SUMPRODUCT function is to create a conditional sum criteria. For example, you may want to find out how much sales were made above the $3,000 transactional level.  See how easy it is with this quick SUMPRODUCT example. DOWNLOAD WORKBOOK...
How To Use INDEX-MATCH Formula   What does it do? Searches the row position of a value/text in one column (using the MATCH function) and returns the value/text in the same row position from another column to the left or right (using the INDEX function) Formula breakdown: =INDEX(array, MATCH...
Jump To A Cell Reference Within An Excel Formula When writing, editing or auditing Excel formulas you will come across a scenario where you want to view and access the referenced cells within a formula argument. This is helpful if you want to check how the formula works or to make any changes to the formula. There is ...