IFERROR
Use IFERROR to trap errors in formulas and display a custom value.
Syntax
=IFERROR(value,"value_if_error")
Example
=IFERROR(100/0,"You cannot divide by
zero")
The value argument can contain cell references.
=IFERROR(value,"value_if_error")
=IFERROR(100/0,"You cannot divide by
zero")
The value argument can contain cell references.