Cells can display error values if the formula contained in the cell cannot be solved or if other anomalous conditions occur.
In Gnumeric all error values have names that start with #. 8 error values are standardized:
| Name | Normal Use |
|---|---|
| #DIV/0! | Division by zero occurred. |
| #N/A | Not applicable. This is the result of the =NA() formula. |
| #NAME? | An unknown function name or other name was encountered. |
| #NULL! | The result of specifying an intersecting range that in fact does not intersect. |
| #NUM! | A formula could not be evaluated because an invalid number was used as argument, for example =SQRT(-1) |
| #REF! | An invalid cell adress or reference was encountered. |
| #UNKNOWN! | Usually the result of importing an unrecognized error from a different file format. |
| #VALUE! | A formula could not be evaluated because the wrong type of argument was used. |