Suppose you apply a formula in a cell
and you get an error, the reason could be anything but the problem lies where
you don’t want to share a report which contains errors. With the use of IFERROR
we can replace any error (e.g. #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or
#NULL!) with almost anything. If you are already using this formula than I am sure that you know its importance but if you have never used it before
then you will become a fan of this.
Just check out below few examples where
we can use it…
Replace Error with Blank i.e. “”
Replace Error with Text
If you like this post, then you can just put in your
email ID at the top right corner of the page and you will get a FREE weekly
newsletter with amazing Excel tips and notification of my latest post on this
blog.