How to get rid of the error message?

Image  Did you know…

there are 7 (+1 if you consider #### an error) types of error message in Excel?  In my experience, most users do not care about the meaning of the errors.  They just want them “disappear” on their worksheet because these errors do not look good.

IFERROR is a simple way to achieve this:

Instead of inputting your formula (e.g. =A1/0) directly, wrap it with IFERROR.

=IFERROR(Your formula,””)

For Excel 2003 or earlier user:

=IF(ISERROR(Your formula),””,Your formula)

Literally, it means IF the formula gives you an error result, then return nothing (“”), else return the result of the formula itself.

Tips: You may replace “” to any text or reference you want, e.g. “Zero/No denominator found”.

btw, if you are interested in learning more about the meaning of each error types, and probably how to avoid errors in building formula, check this site from MS.

Correct an error value

This entry was posted in Excel Tips, Formula and tagged , . Bookmark the permalink.

2 Responses to How to get rid of the error message?

  1. Pingback: Is there a way to negate #NUM! from being displayed when formula refers to an empty cell?

  2. Pingback: hide #div/0!

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s