MS EXCEL - Common Error types in Excel and error handling by Iferror function.
#NAME? error
The #NAME? error occurs when Excel does not recognize text in a formula.
EXAMPLE: SU to SUM
#VALUE! error
Excel displays the #VALUE! error when a formula has the wrong type of argument.
#DIV/0! error
Excel displays the #DIV/0! error when a formula tries to divide a number by 0 or an empty cell.
#REF! error
Excel displays the #REF! error when a formula refers to a cell that is not valid.
EXAMPLE: Delete B column it will give error