Documentation/Calc Functions/ERRORTYPE
Jump to navigation
Jump to search
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
ERRORTYPE
Category:
Spreadsheet
Summary:
Returns the number corresponding to an error value occurring in a different cell. With the aid of this number, you can generate an error message text.
Syntax:
ERRORTYPE(Reference)
Returns:
Returns a positive whole number or a logical value or #N/A which is generated corresponding to an error.
Arguments:
Reference contains the address of the cell in which the error occurs. If the referenced cell doesn't contain any error value then the function returns #N/A.
- If Reference is not a reference to a cell rather an invalid value then the function returns an #N/A.
Additional details:
- For details on each Calc error codes, download and view this Calc Error Codes Documentation.
Examples:
Formula | Description | Returns |
---|---|---|
=ERRORTYPE(A1) where A1 display Err:518 | The function returns the error number displayed in A1. | 518 |
=ERRORTYPE(A3) where A3 contains =TAN() | The function returns the error number for the error caused in the cell A3 by the formula it contains. Here we A3 will have Err:511 error. | 511 |
=ERRORTYPE(A4) where A4 contains =1/0 | Here the cell A4 will have a division error, i.e. #DIV/0! hence the function returns the error number for it. | 532 |
=ERRORTYPE(A2) where A2 contains =ASIN(50) | Here the cell A2 will have a numeric error since the input value can not be greater than 1 or less than 0 for ASIN, i.e. #NUM! hence the function returns the error number for it. | 503 |
=ERRORTYPE(A5) where A5 contains "rabbit" | Here A5 cell has no error value hence the function returns #N/A. | #N/A |
Related LibreOffice functions:
None
ODF standard:
None
Equivalent Excel functions:
None