IFERROR

The IFERROR formula is used to return a specific value if a formula returns an error. To use the IFERROR formula, select the cell where you want the result to appear and enter “=IFERROR(” followed by the formula you want to evaluate and the value you want to return if the formula returns an error. For example, “=IFERROR(A1/B1,”Error”)” would divide the value in cell A1 by the value in cell B1, and return “Error” if the formula returns an error.

Example:

Divide the value in cell A1 by the value in cell B1, and return “Error” if the formula returns an error: =IFERROR(A1/B1,”Error”).