ISERR() vs. ISERROR()

[Karthik-Excelsior]

Hi Excel gurus,

Isn't it odd to have both these functions, when ISERROR() does ALL that ISERR() does except of course not capturing '#N/A' s?

One of the Excel oddities?

Karthik

 

[T. Valko]

Hi Excel gurus,

Isn't it odd to have both these functions, when ISERROR() does ALL that ISERR() does except of course not capturing '#N/A' s?

One of the Excel oddities?

Karthik

If you need to error trap and don't have to worry about #N/A then you can save a couple of keystrokes by using ISERR!

 

[Robert Mika]

And probaly that's why we have ISNA() ...

 

[shg]

ISERR is handy for charting, where you might be happy to allow the #N/A result to propagate to prevent plotting.