Salameander.com

You know how you write formulae in Excel, and depending on the data you point them to you may sometimes get errors like "#DIV/0!" or "#N/A" etc? It's hard on the eyes. To get around this, there's a nifty little worksheet function called ISERROR which you can use with the IF function to get a pristine-looking spreadsheet.

Let's say that you'd like a cell to display a zero if the formula it contains throws up an error message. Here's what you'd need to add on to the existing formula:

=IF(ISERROR(your formula),0,your formula)

It's really simple--try it out! You can replace the zero with pretty much anything really. If you're opting for text, encase them in double quotation marks, e.g. "Ignore".

For further explainations on this and other related functions, just look up the Help file in Excel.