Documentation/Calc Functions/ISERR

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

ISERR

Category:

Information

Summary:

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

Syntax:

ISERR(Value)

Returns:

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

Arguments:

Value is any value or expression which is tested to see whether an error value other than #N/A is present.

Additional details:

Examples:

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

=ISERR(C9) where cell C9 contains =NA() returns FALSE, because ISERR() ignores the #N/A error.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: