While working on Google Sheets, there might be times when you will come across an error message because you broke a formula. And obviously, no one wants these error messages to spam their neat sheet.
Hence, we have brought you the process you can use to hide these error messages using the IFERROR function, provided that the overall data isn’t affected.
How does the IFERROR function work?
The IFERROR work checks whether the formula that you’re utilizing brings about a mistake. In the event that it does, IFERROR permits you to return an elective message or, on the other hand, if you’d like, no message by any stretch of the imagination. This shrouds any potential mistake messages that you when you’re performing calculations in Google Sheets.
There are chances that the error messages may not really show an issue, particularly if you’re performing calculations on data that joins text and information. Assuming you need to conceal these messages totally, you’ll need to nest your underlying equations inside an IFERROR function.
How to Use it?
IFERROR is very easy to use function with two arguments. The syntax of the formula is =IFERROR(A2,”Message”)
The two arguments in the function represent two different formulas. The first one, A2(as in the aforementioned example), is the formula checking for any errors. As the model above shows, this can be utilized to allude to different cells (cell A2 in this guide) to shroud error messages that show up somewhere else.
If you like, these formulas can be nested into an IFERROR function directly.
The second contention in an IFERROR equation is the custom error message that replaces Google Sheets’ own message.
On the off chance that you’d like to have no error message, you can utilize a clear book string as your subsequent argument.
Maybe the vacant text string is “showed” rather than showing a mistake, but as this isn’t noticeable, the cell seems vacant. Not at all like Excel’s own IFERROR recipe, IFERROR in Google Sheets will likewise shroud mistake pointers, the little red bolts that show up above cells to caution you of an error.
The IFERROR will not fix issues with your calculations. Yet, in the event that you need to tidy up your page and wouldn’t fret missing a couple of error messages, IFERROR is an ideal approach to accomplish that in Google Sheets.