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.


If the value in Cell “C2” is an error, IFERROR returns the value to Zero.

  • 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”