Formula mistake may occur in Excel

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.