IFERROR() (Excel 2007)

[nbrcrunch]

I was just reading Bill's "Excel 2007 Miracles Made Easy." Chapter 17 covers the new IFERROR() function. Man, I can see that raising all sorts of "this is so illogical" discussions. The first of 2 agruments is the "is not error" agrument, followed by the "is error."

Seems to me that since the function is named IFERROR, the first argument should be what the error is.

 

[Richard Schollar]

I personally really like it - it provides a simple way to mask errors with an alternative value if required. Of course, you do need to consider whether you really should *want* to mask errors in such a way...

 

[nbrcrunch]

Don't get me wrong. It is not that i don't like the new function, I do. The point I was trying to make was that the arguments seem backwards. If you are checking for an error, then the first thing (in my mind) ought to be the error condition.

If they had named the function CheckIF then I can see the condition you want being listed first and the condition you don't want being second.

Maybe its just me. My wife tells me I'm "truly unique."