Understanding the errors in Excel will skillfully equip you to determine the viable reason and the most useful way to manage these.
Below are the 7 types of errors you might see in Excel
#N/A Error
This is a Value Not Available(#N/A in excel).
You will notice this when you use a Vlookup function and it can’t discover the value (hence Not Available).
Below is an example where I use the VLOOKUP formula to find the cost of an object, but it returns an error when it can’t find that object in the table array.
Solution: Use the IFNA Function to change the #N/A error with a suitable message.
#DIV/0! Error
You’re possible to notice such kind of error when a number is divided by 0.
This name is a division error. You can see an example of this error, it shows a #DIV/0! error in excel as the quantity value is 0.
Solution: IF(A2=0,””,A1/A2)
#VALUE! Error
Value error appears when you utilize an incorrect data type in a formula.
You can see the example below, when I try to add cells that have numbers and symbol A, it shows the value error in excel.
This occurs as you can only add numeric values, but instead, I tried adding a number with a text symbol.
Solution: A simple answer to #VALUE! error in excel is to check your formula to make sure that you only utilized digits. If you’re still seeing an #VALUE!, check for empty cells, missing formulas relating to cells, or any special characters you may be utilizing.
#REF! Error
This is a reference error(#REF! error) and you will notice this when the reference in the formula is no longer useful. This could happen when a formula refers to a cell that is not valid.
In the example, while the formula was =A2/B2, when I remove Column B, all the connections to it became #REF! error in excel.
Solution: Undo your action to solve #REF! error in excel
#NAME ERROR
#name error is possible as a result of a misspelled part.
For example, if instead of VLOOKUP, you by error use VLOKUP, it will provide a name error in excel.
Solution: Simply you just need to correct the function(SU to SUM)
#NUM ERROR
The Number Error can arise if you try and figure a negative value in Excel. For example, the SQRT function cannot calculate the square root of a negative number & will return a #NUM! Error in Excel in Excel.
Another case where you can obtain the NUM error is when you provide a non-valid number argument to a formula.
Solution: All you have to do is convert the negative number to positive
#####
When your cell retains ##### Error in excel, the column does not have a proper width to show the value.
Solution: All you have to do is widen the with and this error will not show you.
