Excel: IfError

Use this feature to handle errors in your formulas by wrapping them in an IFERROR function.

Select the target cells, click the IfError button, choose your error value or message and click OK.

The image below presents a usage example (the right part of the image present what happens when clicking iferror when the dec-2014 is selected).


  • If you click the IfError button on a range of cells that have already been wrapped, it will remove the IFERROR function.
  • The IfError feature ignores cells that do not have a formula and cells that have a formula with multiple IFERROR functions.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk