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. “”

 

1

 

2

 

Replace Error with Text

 

3

3 thoughts on “Magic of IFERROR in Excel……”

Leave a Comment

Your email address will not be published. Required fields are marked *