# Formula mistake may occur in Excel

#### by Sanju[ Edit ] 2009-10-31 18:59:58

**Formula mistake may occur in Excel**
When creating a formula, it is possible a mistake may occur. The formula is not evaluated and Excel displays an error value or message. The common error values that could appear when creating a formula are described below:

**#VALUE**
This error value is displayed if you use a cell reference in a mathematical formula that contains a piece of text. This error also appears if a selection is used without specifying a function.

**#DIV/0!**
This error value is displayed if you divide a value by zero (O).

**#REF!**
This error value is displayed if cell reference does not exist that

is used in the formula.

**#N/A!**
This error value is displayed if value is not available or Excel

cannot find the required value.

**Circular**
The circular reference is a special error message displayed in

**Reference**
form of dialog box. This error message occurs when a formula uses its own result as one of its reference or arguments. This error message is also indicated in the status bar showing the cell address containing the error.