Skip to main content

IFERROR

Returns a specified value if a formula evaluates to an error; otherwise returns the formula result.

CategoryLookup
SyntaxIFERROR(value, value_if_error)

Parameters

ParameterRequiredDescription
valueRequiredThe expression to check for an error.
value_if_errorRequiredThe value to return if the expression evaluates to an error.

Example

IFERROR(value, range, col)

Auto-generated from the EngCanvas function registry.