I’ll re-enable background error checking so we can more easily see the errors flagged in this worksheet.
First, remember that some formulas return an expliciterror code, as we’ve already looked at.
These are definite errors as opposed to potential errors.
For example, here we see a Divide by Zero error and a Value error.
Note that both cells are flagged as errors in addition to displaying an error code.
These errors are being flagged by the rule that checks formulas that result in an error.
Next, we have an inconsistent formula flagged.
In the next example, we see a formula forrunning totalsthat’s being flagged as an error.
The reason for this is that the formula omits other adjacent cells in the region.
This is the way running totals work and so it’s actually not a problem.
The next cell with an error is a number stored as text.
The rule that checks for numbers as text can also be disabled.
The final example is a SUM formula.
The formula is flagged because the reference includes a cell that is blank.
So that’s a few common examples of errors you might see flagged.
