Preventing Formula Errors from Displaying

Formula Errors in Excel – e.g. #DIV/0! or #NULL! – are ugly! And, when you send a spreadsheet that contains formula errors to your client or to your boss … Well, that is not good.

It plants the seed of doubt in the minds of your client or your boss that you have not thoroughly checked the accuracy of your assumptions. Why are there errors showing? What else is missing?

Excel 2007 makes it easy to prevent these formula errors from displaying. We have a new Function in Excel 2007 – The =IFERROR() function and it only requires two arguments. Be warned, however, that if you share your Excel 2007 worksheet with colleagues who are using earlier versions of Excel, this new function will not – well, function! (I could not resist using this pun)

Watch this video to learn how to use the new =IFERROR() function and also the nested =ISERROR() function that is required for people who use Excel 2003 or older versions.

If you enjoyed this Excel tip and my style of training, I invite you to visit my online store to shop securely for my DVD, “The 50 Best Tips for Excel 2007.”

Click here to watch this Excel Video Lesson on YouTube

You can view and download this video – for free – as a Podcast from the iTunes store. Follow this link to my Podcast, Danny Rocks Tips and Timesavers at the iTunes store.

Related Video Lessons:

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn


  1. I think am just having some problems with subscribing to RSS feed here.

Speak Your Mind