# 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