IFERROR function is used to handle errors and return a more appropriate result when any formula generates an error as output. IFERROR's feature returns the result when a formula gives a normal result. But, when a formula returns an error as the output, IFERROR returns an alternative result. IFERROR is a nicer way to detect and manage errors in Excel formulas. IFERROR feature is a newer alternative to the ISERROR function of Excel. IFERROR detects the following errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!. IFERROR can be used to capture and manage such errors produced by other formulas. Example # 1 For example, if we divide something by 0 (Zero), the result will be #DIV/0!. We ca write something friendlier here like "Not Found" or just 0 as the output against this error. =IFERROR(25/0,0) // Gives 0 as the output=IFERROR(25/0,"Not Found") // Gives "Not Found" as the output This formula captures #DIV/0! error that occurs when the denominator is empty or zero and replaces with Zero or "Not Found as shown above. Example # 2 This formula can also used for a kind of validation pupose. For example, if B2 contains 10, C2 is empty, and D2 contains the formula = B2/C2, the following formula will catch #DIV/0! error due to dividing B2 with C2: =IFERROR (B2/C2,"Please enter a value in C2") As long as C2 is empty, D2 will show the message "Please enter a value in C2". When a number is stated in C2, the formula will return the result of B2/C2. Other Error-Related Functions of Excel Excel provides a number of error-related functions, each with a different purpose: The ISERR Function will return True for all types of errors except #N/A error. The ISERROR Function will return True for all types of errors. The ISNA Function will return True only for #N/A error. The ERROR.TYPE Function will return the numeric code for an error. The IFERROR Function captures an error and gives the option to place an alternative result. The IFNA Function captures #N/A errors and gives the option to place an alternative result.