Use the IFERROR function to trap and handle errors produced by other formulas or functions. IFERROR checks for the following errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

=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.

One clap, two clap, three clap, forty?

By clapping more or less, you can signal to us which stories really stand out.