We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)
You can take control of formula errors in your spreadsheets by knowing how to use IFERROR in Excel.
One of the IF functions, IFERROR, can be used with other Excel formulas to help clean up how formula errors look in your spreadsheets.
Use it to display:
- Instructions for users
- Blank cells instead of formula errors
- Any other custom message!
By using IFERROR, if the calculation results in an error, you can customize what to display instead of the error message.
For example, you could display a blank space or instructions on how to fix the error – rather than the default error message.
Using the IFERROR Function in Excel
To use the IFERROR function, simply insert it before your other formulas. Then, at the end of your formula, add what you would like to display instead of the error message.
It would look something like this: