Sign in to confirm you’re not a bot

This helps protect our community. Learn more

Using Excel's IFERROR Function To Trap Spreadsheet Errors

5.08K subscribers

1.4K views 11 years ago

Despite best efforts, errors may occasionally creep into your Excel workbooks. When they do, "upstream" errors in formulas can sometimes cause additional errors in "downstream" cells that depend on the results of the "upstream" calculations. Therefore, as a best practice, you should incorporate routines into your workbooks to trap erroneous conditions and minimize the impact of errors resulting from formulas. Fortunately, Excel's IFERROR function does just that.

...more

...more

Using Excel's IFERROR Function To Trap Spreadsheet Errors

2Likes

1,406Views

2013Sep 13

Despite best efforts, errors may occasionally creep into your Excel workbooks. When they do, "upstream" errors in formulas can sometimes cause additional errors in "downstream" cells that depend on the results of the "upstream" calculations. Therefore, as a best practice, you should incorporate routines into your workbooks to trap erroneous conditions and minimize the impact of errors resulting from formulas. Fortunately, Excel's IFERROR function does just that.

Transcript

Follow along using the transcript.

K2 Enterprises

5.08K subscribers