When a Microsoft Excel formula is calculated, the result may be #VALUE!. This result may be caused by any of the following reasons.

  • Adding cells that contain a non-numerical value.
  • Error with formula

Non-numerical value

Verify the formula is pointing to two or more cells with numbers within them. If you are trying to add cell A1, which equals “100” and A2, which equals “test”. You’ll get this error.

Error with formula

This error is commonly encountered when the formula isn’t formatted correctly or contains other errors as seen in the following example.

=A1+A2 which should be =SUM(A1+A2)

  • Help, examples, and information on Excel formulas.
  • Getting #DIV/0! in Microsoft Excel spreadsheet.
  • Why Excel shows ##### in a spreadsheet cell.
  • See the Excel and formula definition for further information and related links.
  • Microsoft Excel help and support.