Use error-checking functions in Excel: IFERROR, ISERR, and ISERROR

- [Instructor] Excel has a number … of different error checking functions, … and we see them listed in the yellow box on this worksheet. … In this worksheet, … we're simply calculating profit based … on sales minus expenses in column D. … As I hold down the Control key … and use the mouse wheel to zoom in, a simple formula is here … in column D. … Over in column E, we're tracking profit change. … If you grow from 20 to 30, that's 50% growth, … and this formula calculates that result. … Now, as it turns out, … I'm going to be making a presentation of these numbers, … but have been told that some of the numbers are incorrect … so I'm about to adjust some of these. … The meeting starts in 10 minutes or so, … and this expense number actually should have been the same … as the sales 150, … and as I press enter, you can expect the profit to the right … to change zero, but more alarming perhaps … for the moment is this division by zero. … Here's the formula, we're trying to divide by zero. …