How to Write a Nested IFERROR Statement in Excel

To write a nested IFERROR statement in Excel, you need to use the IFERROR function multiple times within one formula. The IFERROR function checks if a given expression returns an error, and if it does, it returns a specified value instead of the error. The syntax for the IFERROR function is:

=IFERROR(value, value_if_error)

Where:

• value is the expression or formula you want to test for an error.
• value_if_error is the value to return if the expression results in an error.

Here's how to create a nested IFERROR statement in Excel:

1. Start by writing the first IFERROR function. This will include the main expression or formula you want to check for errors.
2. For the value_if_error argument, add another IFERROR function. This second IFERROR function will check for errors in a different expression or formula.
3. Repeat this process for as many nested levels as needed, always using the value_if_error argument to include the next IFERROR function.
4. Finally, specify the value to return if all expressions result in errors.

Example

Let's say we have a table with the following data:

We want to calculate the division of the values in columns A, B, and C (A/B/C), but we want to avoid errors due to division by zero. We can use a nested IFERROR statement to achieve this.

1. Start by writing the first IFERROR function: =IFERROR(A1/B1, "Error"). This will return the result of A1 divided by B1 or "Error" if B1 is 0.
2. For the value_if_error argument of the first IFERROR function, add another IFERROR function: =IFERROR((A1/B1)/C1, "Error"). This will return the result of (A1/B1) divided by C1 or "Error" if C1 is 0.
3. Now, we have a nested IFERROR statement: =IFERROR(A1/B1, IFERROR((A1/B1)/C1, "Error")).

The final formula looks like this:

=IFERROR(A1/B1, IFERROR((A1/B1)/C1, "Error"))

With this formula, Excel will check for errors in the divisions of A1/B1 and (A1/B1)/C1, and return the appropriate result or "Error" if an error occurs.