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. …