IFERROR Function
The Excel IFERROR function returns a user-defined, custom value when the embedded formula generates an error. Otherwise, it returns the standard formula result. Using IFERROR is an effective method to identify and handle formula errors. However, you must use more complex statements (for example, the IF function) without error-handling functions. The purpose of using IFERROR … Read more