Common Error Messages

Question 1

VALUE!

Answer 1

Cause:
Occurs when on cell referenced in the formula contains text when the formula requires a number

Fix:
Ensure that the cells referenced in the formula contain valid values

Question 2

DIV/0!

Answer 2

Cause:
Occurs when a cell reference is used that references to a blank cell, or a cell that contains a zero.

Fix:
Ensure that the cell referenced as the divisor in a function is not zero or blank

Question 3

NAME?

Answer 3

Cause:
Occurs when Excel fails to recognize text in a formula.

Fix:
Correct the spelling of the name of the function

Question 4

REF!

Answer 4

Cause:
Occurs if a cell referenced by a formula .

Fix:
Undo the changes made to the best cells or update the formula