Excel IFERROR specific ERROR not all perhaps VBA?
Posted on 2014-10-13
Hello Excelers and Champs
i am looking for a specific function that whenever the result of my formula, has a specific type of error then the IFERROR sort of function can deal with it.
as far as i know, IFERROR treats all errors the same, and we have another one called ISNA and ISERROR is similar like iferror.
what i want in my formula is that if my error is #REF then put NullString otherwise if there is 0DIV error then put 0 and if there is "VALUE" error then put "Not OK" and if there is "#NULL!" error then put "Exceeded" if there is #NAME? error then put "Name Deleted"
i am not sure it could be done with built-in function or if not with existing built in function then is there any UDF that can handle all of these?