347 647 9001+1 714 797 8196Request a Call
Call Me

6 Most Common Excel Errors

February 28, 2015
, , , , , , , ,

Hashtags look cool when seen on Twitter or Facebook but as soon as they start appearing in Excel sheet, you know you are in trouble. Yes, in today’s tutorial we are going to talk about the very annoying Excel errors. Hopefully, after going through the article, you will know the cause of the error and the solution to get rid of it.

1. ###### Error (#######)

This is one of the most common and easiest to tackle error. Basically, it is not a formula based error but occurs when the width of column is small. In the example below, the figure 15000000 is too big and the column width is too small and hence it shows a error.

##### error in Excel

When you increase the width of column A, you will see that the error disappears.

how to avoid #### error in Excel

2. Name Error ( #NAME? )

This error arises whenever Excel is not able to recognize the text in the formula. Like in the example below, instead of writing SUM we have written su and that is the reason we see the #NAME? in A5.

Name error in Excel

You will see that when you have corrected the formula to =SUM(A1:A4), you get the correct answer.

How to avoid Name error in Excel

3. Value Error ( #VALUE! )

Excel shows a Value error whenever the variable mentioned in the formula is wrong. If you see the image below, you will notice that in the formula cell A4 contains text whereas the other 3 cells contain numerical values and hence there is an #VALUE! Error.

Value error in Excel

When you change the formula to A1+B1+C1 then you shall receive the correct answer without any errors.

How to avoid value error in Excel

4. Division Error ( #DIV?0! )

This is very simple to remember. When you attempt to divide a number by zero, you will come across the #DIV/0! error. In the example below, A4 cell contains a 0 and that is the reason the result for A1/A4 is #DIV/0! Error.

Division error in Excel

When you replace the zero with any other number ( 5 in our example), you will see the actual result without any error.

How to avoid Division error in Excel

5. Null Error ( #NULL! )

This is one of the most common types of error. When you forget to separate the two cell references correctly, then you shall receive this error. In the below mentioned example, there is no command between the cell A4 and A4 and hence, you see the #NULL! Error.

Null error in excel

When you add a proper command between the two cell references, then you will get your desired result without any error.

How to avoid null error in excel

6. Reference Error ( #REF! )

When your formula contains some incorrect cell references, then you shall see a Reference Error. This mainly happens when you mistakenly delete any row or column. In the example below, you will see that your data is perfectly filled without any errors.

avoiding reference error in excel

If by chance I delete the 3rd row, then the reference error shall occur as the original formula contains the value of 3rd row.

Reference error in Excel

If you found this article helpful, then share it with your friends and colleagues to make their life a little easy. If you think that we have missed out on some important stuff, then mention it in the comments box below.


About the Author

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.


Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

Post ID = 71895