MS EXCEL - Common Error types in Excel and error handling by Iferror function.

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