IF(ISERROR)

The If(ISERROR) function tests cells for calculation errors that result in #DIV/0! or #NUM!. Just like If(AND), you can use this function to assign a value when the cells return values with calculation errors, and when they’re error-free. The If(ISERROR) function is expressed as: =If(ISERROR(value), value_if_true, value_if_false)