XL-Excellence® - Examples - Formula errors
Hidden errors in spreadsheets are a potential source of weakness. The XL-Excellence® Add-In can reveal such hidden errors.
Seven types of errors can appear in spreadsheets ..
| Error | Cause |
|---|---|
| #DIV/0! | The formula or function used is dividing by zero or empty cells. |
| #NUM! | There is a problem with a number used in the formula. |
| #REF! | Moving or deleting cells caused an invalid cell reference, or function is returning reference error. |
| #N/A | A value is not available to the formula or function. |
| #NULL! | The ranges in the formula do not intersect. |
| #NAME? | The formula contains unrecognised text. |
| #VALUE! | A value used in the formula is of the wrong data type. |
Errors may be outside the visible area of the current tab or on hidden rows or on other tabs so may not be obvious.
The Add-In lists all errors found on all tabs including hidden and grouped areas. Consider the following example of a spreadsheet which contains all seven types of errors ..
The underlying formulae which “force” the errors are ..
.. and the section of the report detailing the errors is ..
If you wish to experiment with the examples discussed above you can download the examples by choosing from the Links section.
Next >>
Download the example