IFERROR function is used to display a specific message or value when a formula returns an error. However, if the formula calculates to an output without an error then the output is displayed. IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements.
Excel IFERROR Function
Syntax
=IFERROR(value,value_if_error)
- value – The value, reference, or formula to check for an error.
- value_if_error – The value to return if an error is found.