You can use the IFERROR function to handle errors in a formula. IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.
| Excel version | Available |
|---|---|
| Excel 2007 | ✓ |
| Excel 2013 | ✓ |
| Excel 2019 | ✓ |
| Excel 2021 | ✓ |
| Microsoft 365 | ✓ |