How To Disguise Error Messages In Excel 2007/2010

You will no doubt have seen one or more error message in Excel indicating a problem with data or a formula. These error messages are there for good reason, but there may be occasions when you want to disguise the errors or substitute a certain value in all cells containing an error messages. For example you might want to sum a range of cells even though some cells contain error messages. This article describes a very useful Excel 2007/2010 function which will do just that, the IFERROR function.

The full article appears here:
http://www.microsofttraining.net/article-1742-how-disguise-error-messages-in-excel-2007/2010.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com