Excel Tip–Messy Error Messages Be Gone!

Wednesday, 23 November 2005

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.


#1Gravatar imagemindy says:

Saw your Pangkor trip photos and it looked smashing! 🙂

#2Gravatar imageMichelle says:

Heh, thanks! Twas a welcome break, to run away from reality for a while…

Leave a Comment:

required asterisk denotes compulsory fields. Off-topic or inappropriate comments will be edited or deleted. Your email address will never be published. This site makes use of Akismet and Gravatar services.

About this post

This post is filed under Work. You can follow any comments to this entry through the RSS 2.0 feed.

The previous post in this category was .

The next post in this category is .

You can leave a comment, or trackback from your own site.