From the course: Excel: Introduction to Formulas and Functions
Join today to access over 24,800 courses taught by industry experts.
Manage Excel formula error indicators - Microsoft Excel Tutorial
From the course: Excel: Introduction to Formulas and Functions
Manage Excel formula error indicators
- [Instructor] Elsewhere in this course I described how you can use tracer errors to indicate cells that either provide a value or use value from other cells. In this movie, I'll show you how to use similar errors to help with your error checking in a worksheet. My sample file is "05_04_identifying" and you can find it in the chapter five folder of the "Exercise Files" collection. In this workbook, I have a single worksheet and I can see that in cell "B7" I have an error. If I look at the formula, I see that I'm trying to divide sales revenue by a blank cell, which would be interpreted as zero, and that's why I get my divide by zero error. However, let's say that it's actually a more complicated formula and I need to use a tool to identify what's going wrong. To do that, I can click the cell that contains the error, in this case "B7", go up to the formulas tab, and then in the "formula auditing" group, I'll click the…
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.