Common Excel errors and Tips to handle them: 5 most common excel errors

Common Excel errors

While working with excel we usually encounter some errors as an output. These common excel errors can impact calculations of the workbook. We will be discussing these Common Excel errors and Tips to handle them in the below article. Hope this will help you understand these error and solutions to handle these.

  1. Value Error (#VALUE!) : These errors reflect when we put a wrong variable value in the formula. Like when adding five values out of which four are numeric and one is aplhabet, then in that case this error will reflect. Let us see below example to understand this.
Common Excel errors
Common Excel errors

In the above example, we can see that while adding numeric values one text value also gets added due to which we got #VALUE. To get rid of this error we need to remove this text value from the sum.

2) Division Error ( DIV/0!): The only reason to get this error is due to the division of any number by zero. Let us understand it by the below example.

Example of excel error
Example of excel error

In the above image, we can see the error comes as we tried to divide 25 by 0. If we replace this zero with some number then we will get some real output instead of #DIV/0! error.

3) Reference Error ( #REF/!): This error comes when your formula has the wrong reference cells. Wrong cell reference comes either due to wrong input of cells or mistakenly we delete some reference row or column. Let us understand it by the below example.

Example of #REF! error
Example of #REF! error

In the above example, we can see that when mistakenly deleted row 6 formula row moved up by one row and the cell reference for row 6 converted to #REF!. To avoid this error we should keep in mind every cell whenever there is a requirement to delete a row or column.

4) Null Error ( #NULL! ): Null Error ( #NULL! ) comes when we forget to separate any two cell references while doing the calculations.

#NULL error example
#NULL! error example

In the above example, we can see that we miss the operand between D5 and D6 due to which #NULL! error occurs. It is very important to put operands between every cell reference for any error-free calculation.

5)  Name Error ( #NAME? ): This error comes when we use some excel function but excel is not able to recognize it. It could happen when we are using an incomplete or wrong function name, a function that is actually not an excel function, etc. Let us see the below example.

Example of #NAME? error in excell
Example of #NAME? error in excel

In the above example, we can see that we are trying to use the average function but write it as aver instead of AVERAGE. To avoid this kind of error we should use the auto-suggested option of excel. That will help in minimizing the error.

That’s all for now. Let meet again with some new function or a new topic.

You can read more on this from the below articles.

https://www.sganalytics.com/blog/gearing-excel-error-handling/

Leave a Comment

Your email address will not be published. Required fields are marked *