Documentation/Calc Functions/ISERROR

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

ISERROR

Category:

Information

Summary:

Tests for error conditions, including the #N/A error value, and returns TRUE or FALSE.

Syntax:

ISERROR(Value)

Returns:

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

Arguments:

Value is or refers to the value to be tested. ISERROR() returns TRUE if there is an error and FALSE if not.

Additional details:

Examples:

=ISERROR(C8) where cell C8 contains =1/0 returns TRUE, because 1/0 is an error.

=ISERROR(C9) where cell C9 contains =NA() returns TRUE.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: