If the ERROR.TYPE function in Excel not working for you, ensure the formula is correct, check for errors in the referenced cell, or repair Excel.

Here are some of the new features in Excel 2002 that you’ll find very handy. Formula Auditing was called Auditing in prevision versions. It helps you reduce errors in your workbooks. To evoke it, ...