Financial maths competition
Try our live financial maths quiz / competition
Home Register Contact About Us

  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 ..

Example of spreadsheet containing 7 types of errors

The underlying formulae which “force” the errors are ..

Formulae underlying examples of 7 types of errors

.. and the section of the report detailing the errors is ..

Section of report detailing errors

If you wish to experiment with the examples discussed above you can download the examples by choosing from the Links section.


Sitemap | Terms of use | Privacy | Contact us
- -