IFERROR function

You can use the IFERROR function to trap and handle errors in a formula. IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.

=IFERROR(Value,Value_if_error)

Example
If the value in Cell “C2” is an error, IFERROR returns the value to Zero.
=IFERROR(C2,0)

• Type “IFERROR(=”
• Click “fx” in the formula bar.
• In “Value”, Click on cell “C2”.
• In “Value_if_error”, type “0”
• Click on “OK”
• Drag from “D2 to D4”