From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

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

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

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

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

“

- Excel has a number of 2 different error checking functions 3 and we see them listed in the yellow box 4 on this worksheet. 5 In this worksheet, 6 we're simply calculating profit 7 based on sales minus expenses in column D. 8 As I hold down the control key 9 and use the mouse wheel to zoom in. 10 Simple formulas here in column D. 11 Over in column E we're tracking profit change. 12 If you grow from 20 to 30, 13 that's 50% growth 14 and this formula calculates that result. 15 Now as it turns out, 16 I'm going to be making a presentation 17 of these numbers, 18 but I've been told that some 19 of the numbers are incorrect, 20 so I'm about to adjust some of these. 21 The meeting starts in 10 minutes or so, 22 and this expense number 23 actually should have been the same 24 as the sales 150. 25 And as I press enter, 26 you can expect the profit 27 to the right to change zero. 28 But more alarming perhaps 29…

Contents