IFERROR Google Sheets: Everything you Need to Know
If you need help hiding errors, this article is for you! Learn the different types of errors in Google Sheets and how to hide them using IFERROR. Learn the advantages and disadvantages of using it in your spreadsheets and dashboards!
Google Sheets IFERROR Function
IFERROR is used to replace the error code with a statement, so that if one occurs, it makes troubleshooting easier.
Can either be the reference to a cell or include a whole formula inside, hiding the errors.
If an error occurs, this will be displayed as the value. If you leave this blank, the output will be blank as well.
If the reference does not produce an error, the function will display the value as is.
IF ERROR EXAMPLES
Interpret #N/A from VLOOKUP as “Value not found”
If you place VLOOKUP formula inside IFERROR, the error won’t even show up in the sheet.
Indicate #VALUE as improper data type
You can also wrap it around the original formula to hide the error and save space in your sheet:
Cannot distinguish between different types of Google Sheets errors
The formula will still display the same message even if a different error appears:
Here, the formula is programmed to interpret #VALUE! (improper data type) but the real error code is #DIV/O! (division by zero).
If you need to be able to know which is which, you can combine ERROR.TYPE with IF and SWITCH , as in this example:
This determines the type of error and displays the appropriate message. Click here to learn more about this technique.
If you need to hide the error, you can use this function by only adding the reference inside it:
This is not recommended; there are functions and formulas that also set blank values as valid output for a specific input value. This will hinder your ability to spot issues in your Google Sheets dashboard.
Related IF Functions
IF: Allows you to check for specific conditions across a dataset
SUMIF: Use to sum numbers if they meet a certain condition..
SUMIFS: Sums data from cells that meet multiple criteria
COUNTIF: count data if it fulfils certain criteria
COUNTIFS: Count data that fulfils two or more criteria.