Excel Errors

A number of Excel errors appear to arise again and again in different spreadsheets.

Therefore, this page has been created to discuss some of the most commonly encountered Excel errors, and to show you how to go about identifying the underlying problems, and fixing the errors.


Excel Formula Error Types

If Excel is able to detect a mistake in your formula, there are a number of Excel error types (eg. #NULL!, #DIV/0!), that may be generated, to indicate different Excel errors. This provides you with information about the cause of the problem. Therefore if you understand what each of the Excel error codes means, you are halfway to fixing the problem.

Click on the link below, to learn more about each of the Excel formula error messages, and to find out how to go about fixing the associated errors.

Other Common Problems with Excel Functions & Formulas

The table below lists some of the more frequently encountered Excel errors, when working with functions and formulas. Click on the associated link for information on why each error might have arisen, and how to resolve the problem.

If your Excel problem doesn't fit into one of the above categories, it is a good idea to request help on one of the popular Excel forums. For example, the forum on the mrexcel.com website has several knowledgeable and helpful Excel contributors, who are generally very keen to answer Excel queries.