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
38,329 total views, 258 views today