Hashtags look cool when seen on Twitter or Facebook but as soon as they begin appearing in Excel sheets, you recognize you’re in trouble. Yes, in today’s tutorial we are getting to mention the very annoying Excel errors. Hopefully, after browsing the article, you’ll know the explanation for the error and therefore the solution to urge obviate it. Common Excel Errors
1.###### Error (#######)
This is one of the foremost common and easiest to tackle errors. Basically, it’s not a formula-based error but occurs when the width of a column is little. within the example below, figure 15000000 is just too big, and therefore the column width is just too small and hence it shows an error. Office.com/setup
When you increase the width of column A, you’ll see that the error disappears.
2.Name Error ( #NAME? )
This error arises whenever Excel isn’t ready to recognize the text within the formula. Like within the example below, rather than writing SUM we’ve written so which is that the reason we see the #NAME? in A5.
You will see that once you have corrected the formula to =SUM(A1:A4), you get the right answer.
3.Value Error ( #VALUE! )
Excel shows a worth error whenever the variable mentioned within the formula is wrong. If you see the image below, you’ll notice that within the formula cell A4 contains text whereas the opposite 3 cells contain numerical values and hence there’s an #VALUE! Error.
When you change the formula to A1+B1+C1 then you shall receive the right answer with no errors.
Division Error ( #DIV?0! )
This is very simple to recollect. once you plan to divide variety by zero, you’ll encounter the #DIV/0! error. within the example below, the A4 cell contains a 0 which is that the reason the result for A1/A4 is #DIV/0! Error.
When you replace the zero with the other number ( 5 in our example), you’ll see the particular result with no error.
Null Error ( #NULL! )
This is one of the foremost common sorts of error. once you forget to separate the 2 cell references correctly, then you shall receive this error. within the below-mentioned example, there’s no command between the cell A4 and A4 and hence, you see the #NULL! Error.
When you add a correct command between the 2 cell references, then you’ll get your required result with no error.
Reference Error ( #REF! )
When your formula contains some incorrect cell references, then you shall see a Reference Error. This mainly happens once you mistakenly delete any row or column. within the example below, you’ll see that your data is perfectly filled with no errors.
If accidentally I delete the 3rd row, then the reference error shall occur because the original formula contains the worth of the 3rd row.
In this article, we wrote about the most common errors in Microsoft Excel. we hope this article is helpful. If you have any confusion related to this article then visit office.com/setup.