Documentation/Calc Functions/ERRORTYPE

From The Document Foundation Wiki
Jump to navigation Jump to search


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:

Note pin.svg

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


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