Documentation/Calc Functions/ERRORTYPE

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


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:

If an error occurs, the function returns a logical or numerical value.

Arguments:

Reference contains the address of the cell in which the error occurs.

Additional details:

The Status Bar displays the predefined error code from LibreOffice if you click the cell containing the error.

Examples:

If cell A1 displays Err:518, the function =ERRORTYPE(A1) returns the number 518.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: