Iferror not compatible with 2003

[Immortal2014]

I have a workbook in office 2016 and i use iferror function that is not compatible with office 2003. I have already passed in 3000 around cells. What can I do;
Thanks for any advice

[oeldere]

iferror is not available in the excel 2003 version.

Use te available formula.

But since you don't add what kind of failure you have in your file, I will not comment on that.

[Richard Buttrey]

Hi,

If you want to use the same workbook with both 2003 & 2007+ then you'll need to convert them to

=IF(ISERROR(your_formula),"error text",your_formula)

[Tony Valko]

The best error trap depends on the specific formula.

Your goal should be to avoid repeating the formula but sometimes that's not possible:

=IF(ISERROR(your_formula),what_to_do_if_error,your_formula)

Let's assume that formula normally returns a TEXT value. When an error is generated you would rather have a blank returned instead. A better error trap would be:

=LOOKUP("zzzzz",CHOOSE({1,2},"",your_formula))

That's just one example. As I noted, the best error trap depends on the specific formula.

[Immortal2014]

Thanks all of you for your answers, i make the changes soon.

[Tony Valko]

You're welcome. We appreciate the feedback!

[Immortal2014]

All ok guys, the =IF(ISERROR(... works great!