Excel Errors commonly occur when there is a name, value, division, or reference error. Hopefully, after going through the article you will know the cause of the error and how to remove it.
1 . Name Error : (#NAME)
This Error usually arises when excel is not able to recognize the text in the formula.
Example: Write Su instead of SUM, Error occurs #NAME
Solution: Correct the formula to =SUM (A5:A4), you will get the correct answer
2 . Value Error : (#VALUE)
This Error arises when the variable mentioned in the formula is wrong
Example: Formula Cell A2 contains text whereas the other 5 cells contain numerical value hence, #VALUE Error occurs.
Solution: When you change the formula you shall receive the correct answer.
3 . Division Error : (#DIV?0!)
When you attempt to divide a number by ZERO you will come across by #DIV?0! Error
Example: A2 cell contains 0 and the result of A1/A5 is #DIV?0! Error
Solution: When you replace 0 with any number like 7 you will get the correct answer.
4 . Reference Error : (#REF)
When your formula contains any incorrect cell reference this error arises. Mainly occurs when you delete a row or column.
Example: If I delete the 3rd row then an error occurs because the original formula contains the value of the third row.
Solution: Not Delete any row or column and add data carefully.