IFERROR function in Excel

This example demonstrates how the function works IFERROR (IFERROR) in Excel.

1. Excel throws an error # DIV / 0! (#DIV/0!) when the formula tries to divide numbers by 0.
2. Let’s try to use the function IFERROR (IFERROR). In the example below, in cases where a cell contains an error, an empty string (“”) is displayed.

   =IFERROR(A2/B2,"")

   =ЕСЛИОШИБКА(A2/B2;"")