Financial		Logical		Informational		Text
Mathematical		Statistical		Lookup		Reference		Formula Errors

#N/A
Problem : Excel display this error when a value is not available to formula.
Resolution: To be updated
Example:To be updated

#VALUE!
Problem : Excel displays the #VALUE! error when a formula has the wrong type of argument
Resolution: To be updated
Example:To be updated

#REF!
Problem : Excel displays the #REF! error when a formula refers to a cell that is not valid.
Resolution: To be updated
Example:To be updated

#DIV/0!
Problem : Excel displays the #DIV/0! error when a formula tries to divide a number by 0 or an empty cell.
Resolution: To be updated
Example:To be updated

#NUM!
Problem : Excel displays the #NUM! error when a formula has unacceptable arguments
Resolution: To be updated
Example:To be updated

#NAME?
Problem : The #NAME? error occurs when Excel does not recognize text in a formula.
Resolution: To be updated
Example:To be updated

#NULL! Error
Problem : #NULL! errors occur when the two or more cell references are separated incorrectly in a formula
Resolution: To be updated
Example:To be updated

########!
Problem : Error occur when number in a cell is too wide for the cell to display it
Resolution: Extend the Column width
Example:Enter 25647.2541 in a cell of width 4

Click Here to Download a copy of ExcelTechie Excel Formulas Errors Workbook