Solution: You can use any of the error-handling formulas such as ISERROR, ISERR, or IFERROR along with IF. The following topics explain how to use IF, ISERROR and ISERR, or IFERROR in a formula when your argument refers to error values. Notes: ... =IFERROR(Formula,0) is much better than =IF(ISERROR(Formula,0,Formula))