Google Sheets IFERROR Function: Syntax, Examples & Tips

value:
The value or expression that you want to check for an error. This can be a cell reference, a formula, or a direct value.

value_if_error:
The value to return if the value results in an error. This can be a specific value, a formula, or a cell reference that defines what should be returned in case of an error.

What is the IFERROR Function?

The IFERROR function in Google Sheets is a useful tool that helps manage errors in formulas. It allows you to catch and handle errors gracefully, providing a way to display a custom message or an alternative result when an error occurs. This function is particularly helpful in ensuring that your spreadsheets remain clean and user-friendly, even when there are issues with the data or calculations.

In simpler terms, IFERROR helps you avoid displaying error messages like #DIV/0!, #N/A, or #VALUE! in your sheets, allowing you to present a more polished output.

A Practical Example

Imagine you are calculating the average sales per product in a sales report stored in a Google Sheets document:

Sales Data Table:

You want to calculate the average sales per product. However, if the NumberOfSales is zero, it will result in a division error.

IFERROR Formula

To achieve this, you would use the IFERROR function as follows:

=IFERROR(B2/C2, "No Sales")

In this formula:

• B2 is the cell containing the TotalSales.
• C2 is the cell containing the NumberOfSales.
• "No Sales" is the value that will be returned if there is an error (like division by zero).

Result of the Formula

When you apply the IFERROR formula to the Sales Data Table, the output would look like this:

In this case, for ProductID 102, the IFERROR function prevents a division error and instead displays "No Sales".

Why Use IFERROR?

IFERROR is beneficial because it simplifies error handling in your spreadsheets. It allows you to provide clear, user-friendly messages instead of confusing error codes. This enhances the readability of your data and makes it easier for others to understand your calculations.

Key Takeaways:

• IFERROR: A function that catches errors in formulas and allows you to return a custom message or alternative result.
• Error Management: Helps maintain a clean and professional appearance in your spreadsheets by avoiding error messages.
• Common Use Cases: Ideal for financial calculations, data analysis, and any scenario where errors may occur in formulas.

IFERROR is an essential function for anyone working with data in Google Sheets, providing a powerful way to enhance data presentation and usability.

Happy spreadsheeting!