Trap and handle errors

Return value 
The value you specify for error conditions.

value - The value, reference, or formula to check for an error.
value_if_error - The value to return if an error is found.

=IFERROR(value, value_if_error)

Example #1
In the example shown, the formula in E5 copied down is:
This formula catches the #DIV/0! error that occurs when Qty is empty or zero, and replaces it with zero.

Example #2
For example, if A1 contains 10, B1 is blank, and C1 contains the formula =A1/B1, the following formula will catch the #DIV/0! error that results from dividing A1 by B1:

=IFERROR (A1/B1,"Please enter a value in B1")
As long as B1 is empty, C1 will display the message "Please enter a value in B1" if B1 is blank or zero. When a number is entered in B1, the formula will return the result of A1/B1.

Example #3
You can also use the IFERROR function to catch the #N/A error thrown by VLOOKUP when a lookup value isn't found. The syntax looks like this:

=IFERROR(VLOOKUP(value,data,column,0),"Not found")
In this example, when VLOOKUP returns a result,  IFERROR functions that result. If VLOOKUP returns #N/A error because a lookup value isn't found, IFERROR returns "Not Found".