When you introduce the formula it may appear as cell content
#TEXT, being TEXT a value that can
change according to the type of error. For example:
##### will
appear when the colunm width is insufficient or when a date or time is used in negative
form.
#¡NUM! when
you have introduced an incorrect type of argument or operant, like an addition on
texts.
#¡DIV/0! when
a figure is divided by zero
#NAME? when
Excel does not identify the formula's text.
#N/A when
a value is not available for a function or formula.
#¡REF! when
a cell reference is invalid.
#¡NUM! when
invalid numerical values are typed in a formula or function.
#¡VOID! when
an intersection of two areas that do not intersect is specified.
In all these cases, the cell will also
contain the symbol on the left top corner: .
This symbol should be used as we have shown above.
