Documentation/Calc Functions/IFERROR

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

IFERROR

Category:

Logical

Summary:

Returns the value if the cell does not contains an error value, or the alternative value if it does.

Syntax:

IFERROR(Value;Alternate_value)

Returns:

Arguments:

Value is the value or expression to be returned if it is not equal or results in an error.

Alternate_value is the value or expression to be returned if the expression or value of Value is equal or results in an error.

Additional details:

Examples:

=IFERROR(C8;C9) where cell C8 contains =1/0 returns the value of C9, because 1/0 is an error.

=IFERROR(C8;C9) where cell C8 contains 13 returns 13, the value of C8, which is not an error.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: