If you’ve been working with Excel long enough you’ll notice that some solutions work but can be dangerous and lead to problems.
This is the case with Excel’s IFERROR function. People decide to hide errors for cosmetic reasons or to replace the error with a descriptive message. A few weeks ago I was about to write a post to explain potential dangers of Excel’s IFERROR function.
I googled it and found this post by Matthew Kuo.
It’s so close to what I was going to say that it’s easier to share Matthew’s link and save two hours of writing and screen shot editing!
Thanks Matthew! Check out Matthew’s site MBAexcel.com