Formula mistake may occur in Excel

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

Tagged in:

1315
like
0
dislike
0
mail
flag

You must LOGIN to add comments