Error Value

Cause

Solution

#####

Column is too narrow to show the whole number

Widen the column.

#REF!

Cell reference in formula is not valid because you deleted the cell or pasted something else over it.

Rewrite the formula.

Delete ROW 2

The formula A1+A2 will give the value #REF

#VALUE!

A formula expects a number but the cell you name has only text in it. For example the formula =B3+B4 would give this error if B4 contains text.

Rewrite your formula to refer to the correct cells or use a function that will ignore text, like = SUM(B3:B4).

Put a text in A2

#N/A

A value you used in a formula or as an argument for a function is "Not Available" now. You can enter this expression in a cell yourself to show that you haven’t entered data yet.

To do the calculation you will have to get the values.

#DIV/0!

Your formula tried to divide with a cell which is blank or has value of 0.

Change the cell reference or enter a non-zero value in the cell to divide with. If the cell contains #N/A (for Not Available), then the formula will give #N/A as the answer, too.

#NAME?

You used a name for a range or a function that Excel does not understand. Perhaps you misspelled it or left out the colon in a range reference.

Correct spelling. Include the colon in all ranges. Make sure the name or function exists.

=A1+b= #NAME

#NUM!

There is a problem with a number in a formula or function. It may be too large or small for Excel to handle. It might be the wrong type for a function, like text instead of a number.

Check for wrong type of arguments. Revise the formula or change your whole strategy if the answers will not fit in Excel.

#NULL!

You referred to the intersection of two data regions which do not really intersect.

Correct your formula. Possibly use the union of two regions that do not intersect instead.

instead of

=SUM(A1:A5)