Magic of IFERROR in Excel……

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 hide 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 very 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

22,786 total views, 18 views today