In this Excel tutorial video, we gonna learn how to use the IFERROR function in Excel to work around with common errors in Excel such as DIV/0!, N/A, NAME?, NULL!, NUM!, REF!, and VALUE! etc.
Instead of getting an error as a result, we can replace the error with custom text or a dash - or a empty "" (just opening and closing double quotes).
It is very common to get errors in Excel when using the VLOOKUP function, the Average function, when we divide something by zero or any other function or Excel formula, for example.
So, whenever you get an error message as a result, you can use the IFERROR() to customize the error message, to automate the error message, basically.
#JopaExcel #Dashboard #Excel