While trying to help the author of

CodePudding user response：

Next to IFERROR(), there also is the ISERROR() function, which can be used as an input for an IF()-clause:

=IF(ISERROR(value),value_if_error,value_if_no_error)