From the course: Excel Formulas and Functions Quick Tips
Join today to access over 24,900 courses taught by industry experts.
Include IFERROR to trap errors in formulas - Microsoft Excel Tutorial
From the course: Excel Formulas and Functions Quick Tips
Include IFERROR to trap errors in formulas
- [Instructor] IFERROR is a great function for trapping and handling errors that can otherwise wreck a formula. This formula uses INDEX and MATCH to look up the status of a particular state found in column E. But if I put something in here that doesn't have a listing in column E, I'll get a nasty, confusing error. Let's wrap the entire formula around the IFERROR function. Here's my formula. Right after the equal sign, I'm going to wrap the entire thing around IFERROR. I'll open my parentheses. I can keep this formula exactly how it is, and all the way at the end, I'll put a comma. Now, I can write what happens if there's an error. In this case, I'll write "Not found". Close the parentheses, hit Enter, and my error handling is working already. If it finds something legit, it's still going to complete the formula.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.