Excel IFERROR Function

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

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

For example:

=IFERROR(A1/B1,"")

If B1 is 0 or empty formula will return #DIV/0!

however, since we are using IFERROR formula, we have told excel to return empty cell if the error shows up.

You can use this formula to check multiple conditions too. For example, Vlookup

#IFERROR