How To Manage Excel Formula Error Indicators In Excel For Mac


show more Managing Excel formula error indicators provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Managing Excel formula error indicators

The Excel program is able to determine when a cell contains an error, and in some cases identify what type of error has occurred. In addition to displaying error messages instead of formula results, Excel will also display indicators in the cell where it thinks the formula could be incorrect, inconsistent, or contain some other mistake. In this movie, I'll show you how to manage those indicators and turn off the ones you don't want to appear. So in this worksheet I have a couple of potential errors - well, one definite error and one possible error. I'll start with the definite error, and that's here in cell B7, where I have Average per Sale, and the cell displays the divide by zero error.

So let's see what's happening. I'll take a look at the formula. So it's dividing the value in B3, the sales revenue by the value in B4. So there is the problem. There is no value in B4, so that means that it's trying to divide by zero, which is not allowed in mathematics...

Managing Excel formula error indicators
Video duration: 4m 42s 6h 32m Beginner

Viewers:

Managing Excel formula error indicators provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...