Creating an IFNOTERROR function

Excel has an IFERROR function, but it does not have an IFNOTERROR function. In this exercise, you’ll build that logic yourself by combining IF with ISERROR.

IFERROR lets you return a different value when a formula has an error. Here, we want the reverse idea: return one label when a value is an error, and another label when it is not.

You can do that by combining IF with ISERROR.

=IF(Logical_test, Value_if_true, Value_if_false)

=ISERROR(value)

Quick reminder if this is your first time here: you can see the finished solution in the Answer tab at the top of the page.

What you need to do

The sheet has two formulas in column B. One returns an error, and one returns a normal result.

Your goal is to fill the Custom formula column (column C) with:

• "Error" when the formula in column B returns an error
• "Not error" when the formula in column B does not return an error

Follow these steps:

1. Click cell C2.
2. Start an IF formula that checks whether B2 is an error.
3. Use ISERROR as the logical test.
4. Return "Error" when ISERROR returns TRUE.
5. Return "Not error" when ISERROR returns FALSE.
6. Press Enter.
7. Rewrite or copy the formula from C2 down to C3.