How to Hide Errors in Google Sheets – Guide
The IFERROR function checks whether a formula you use returns an error. If this is the case, IFERROR allows you to return an alternate message or, if you prefer, no message at all. Hides possible error messages that may appear when performing calculations in Google Sheets. No spreadsheet is perfect, so error messages don’t necessarily indicate a problem, especially when you’re performing calculations on a dataset that combines text and data. To completely hide these messages, you must nest (combine) their initial formulas into an IFERROR formula. The second argument in an IFERROR formula is the custom error message, replacing the Google Sheets message itself. For example, the image above shows that it is not possible to divide zero by zero. Instead of displaying the Google error message (#DIV/0!), a custom error message is displayed. Instead of displaying an error, the empty string is “displayed”, but since it is not visible, the cell appears empty. Unlike Excel’s IFERROR formula itself, IFERROR in Google Sheets also hides error indicators: the little red arrows that appear over cells to warn you of an error.
Hiding errors using IFERROR
A great way to hide errors is by using the IFERROR function. The IFERROR function will allow you to return any desired value if there is an error value, or you can do it so that errors are displayed up as blank spaces.
The syntax of the IFERROR function is:
Here is an example of how the IFFERROR function can be used to hide error messages.
dividing by zero
Filtering Errors
Finally, if you want to hide every line that has an error message, you can do it with filtering.
Final note
I hope you like the guide How to Hide Errors in Google Sheets. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.
