EXCEL ERRORS

 

#NAME

this error shows then when you entered something in your formula that excel interprets as an incorrect cell reference, range, or function name ..

 

#REF!

this error shows that you might have relocated or deleted a cell that is referenced in the formula. 

 

#VALUE!

this error shows that you are probably using text in a formula when another argument(number) is required.

 

#DIV/0!

this error shows that you divide a number by zero or divide by a reference to an empty cell Remembered, division by zero is mathematically undefended.

 

#NUM!

this error shows when you try to pass an incorrect argument, like text, to a function that is expecting a numerical value.

 

#######

this error shows that number is too wide to be displayed in the cell. Double click the column separator to resolve this error.