ERRORTYPE function
From Apache OpenOffice Wiki
< Documentation | How Tos
ERRORTYPE
Returns the number corresponding to an error value.
Syntax:
ERRORTYPE(reference)
- returns the error number of the cell referred to by reference, or #N/A if that cell has no error.
- Note that if you click in a cell containing an error, the status bar shows a fuller description of that error.
Example:
ERRORTYPE(A1)
- if cell A1 shows error Err:518, returns 518.
See Also
