Microsoft Excel – Tips and Tricks

Created by Christopher Leonard, Modified on Mon, 7 Apr at 10:34 AM by Christopher Leonard

Application – Microsoft Excel – Tips and Tricks

Errors And Solutions

What You See	Problem	Fix
###### error	The column is not wide enough to display all the characters in a cell.	Extend the width of the column.
#DIV/0! Error	Excel displays this error when a number is divided either by zero (0) or an empty cell	Change the divider to a value that is not equal to 0
#Name? error	The text in a formula is not recognized by Excel. This is caused by misspelling the function names. For instance =su(A1:A7) will result in the #Name? error.	Correct the error by entering =sum (A1:A7).
#Value! error	This error will be displayed if the formula includes cells that contain different data types. = B1(85) + B2(75) +B3(data) will result in the #Value! error message.	Replace B3(data) with a numeric value and the error will be corrected.
#REF! error	The error will be displayed when a cell reference is not valid. Deleting cells that were referred by other formulas will cause this error.	Refer the cells to the correct ranges and the error will be corrected.
#NUM! error	The formula or function contains invalid numeric values.	Using $ ,% symbols with the number can result in this error, so avoid using these.
#NULL error	Excel displays this error when you specify an intersection of two areas that do not intersect (cross). The intersection operator is a space character that separates references in a formula. =Sum (A1:A2 C3:C5) returns the #NULL error because the two ranges do not intersect.	=SUM (A1:F1 B1:B10) will return the correct reference.