IFERROR

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

Example

IFERROR(#B;100)