IFERROR – Replacing error messages in Microsoft Excel with blanks


If you have to divide figures in one column by figures in another column, you may not want the error message #DIV/0 to appear if one of the figures in a second column is a zero. Or, if you are using VLOOKUP, you may not want #N/A to appear if what you are looking up does not appear in your data table.

I will demonstrate first of all with a division, then with a VLOOKUP.

Select the cell for the first of your division calculations.

Type in an equals sign as all formulae and functions start with an equals sign.

Now type IFERROR followed by an opening bracket (; now type in the formula to be checked, then type a comma, then your required result if there would be an error, followed by a closing bracket. Then click the tick to the left of the formula bar or press…

View original post 200 more words


About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

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

WordPress.com Logo

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s