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


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
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 )

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.