Use this feature to handle errors in your formulas by wrapping them in an IFERROR function.
Select the target cells, click the IfError button, choose your error value or message and click OK.
The image below is an example of where the IfError function has been used. On the right of the image, you can see what happens after clicking the IfError function for the data on the left.
- If you click the IfError button on a range of cells that have already been wrapped, it will remove the IFERROR function.
- The IfError feature ignores cells that do not have a formula and cells that have a formula with multiple IFERROR functions.