Syntax

IFERROR(possibleError:<Any>;replacement:<Any>)

Description

IFERROR returns a value that specifies if a formula evaluates to an error.

if the expression in 'possibleError' is an ERROR value, then 'replacement' is returned, otherwise the value of 'possibleError' is returned
both, 'possibleError' and 'replacement', must have the same type
if 'replacement' is also an ERROR, then that error value will be the result of IFERROR

IFERROR(#B;100)