From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using the ISERR, ISERROR, IFERROR, and ISNA error-checking functions

Using the ISERR, ISERROR, IFERROR, and ISNA error-checking functions

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Using the ISERR, ISERROR, IFERROR, and ISNA error-checking functions

“

- Excel has a number of error-checking functions. Unfortunately, they're not all located in the same place. So if you were trying to track them down, you might go to the Formulas tab. Eventually, you might come to More Functions, Information Functions. Here are a couple of them right here. ISERR, ISERROR. Another one is found in the category called Logical. It's I-F-E-R-R-O-R, IFERROR. And there's another one that does a number of things, including a function that lets us circumvent errors. That's called AGGREGATE, and it's covered in another movie. In this worksheet here, we're tracking sales and expenses and profits. And then in rows 7, 8 and 9, we've got some formulas here. These formulas involve division, calculating differences, dividing by the starting point, to get a percent of change. Now, maybe the person who set up the formulas just didn't think of this possible situation. When the sales and expenses are the same, and I'm going to make that be the case in April. I'll change…

Contents