Getting #VALUE! in Microsoft Excel spreadsheet
Updated: 01/05/2018 by Computer Hope
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)