IfError

 

This example illustrates the IFERROR function in Excel.

1. For example, Excel displays the #DIV/0! error when a formula tries to divide a number by 0.

Div/0! Error

2. Use the IFERROR function. If a cell contains an error, an empty string ("") is displayed.

IfError Function in Excel