FUNCTION CATALOGUE / LOGICAL
IFERROR Excel function
Returns a fallback value if an expression errors.
Correct sentence to use
Calculate [expression], or return [fallback] if it errors.
Modify this query in PlainFormula →Example formula
=IFERROR(A2/B2,"Check values")
Returns a fallback when the expression returns an error.
Syntax
IFERROR(value, value_if_error)
Argument signature: value, value_if_error
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.