{"id":240,"date":"2014-09-24T01:43:28","date_gmt":"2014-09-23T23:43:28","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=240"},"modified":"2024-06-03T03:56:47","modified_gmt":"2024-06-03T01:56:47","slug":"iferror-introduction","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/iferror-introduction\/","title":{"rendered":"IFERROR Function: Introduction"},"content":{"rendered":"

What does it do? <\/strong><\/em><\/p>\n

It returns a value that you set if a formula<\/a> has an error<\/p>\n

Formula breakdown: <\/strong><\/em><\/p>\n

=IFERROR(Value<\/span>,Value if Error<\/span>)<\/p>\n

What it means: <\/strong><\/em><\/p>\n

=IFERROR(The Formula<\/span>,What do you want to show if The Formula has an error?<\/span>)<\/p>\n

\n

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<\/strong> function which allows you to replace the error it with a 0 or a blank cell.<\/p>\n

\n

Download excel workbook<\/i><\/span>IfError.xlsx<\/span><\/a><\/p>\n<\/div>\n

We want to get the average sale of each record<\/strong>. However we need to handle division by zero errors gracefully<\/strong>.<\/p>\n

STEP 1:<\/span><\/strong>\u00a0We need to enter the IFERROR<\/strong> function in a blank cell:
\n=IFERROR(<\/span><\/code>
\n\"IFERROR<\/p>\n

 <\/p>\n

STEP 2:<\/strong> <\/span>The IFERROR<\/strong> arguments:<\/p>\n

\n
\n

Table of Contents<\/p>\n<\/span><\/div>\n