Skip to main content
Version: Streamsheets 3.0

IFERROR

Returns specified ErrorValue, if given value represents an error. If not, this function simply returns given value.

Syntax

=IFERROR(Value, ErrorValue)

Arguments

NameTypeDescription
ValueValueValue to check against each defined error values.
ErrorValueValueThe value to return, if first value returns an error.

Return

TypeDescription
ValueErrorValue, if error occurs, otherwise the Value.

Examples

FormulaResultComment
=IFERROR(2 / 0, "Warning")
"Warning"As the Value leads to a DIV/0 error, the text "Warning" is displayed.