|
|
|
 |
| Errors in
Formulas |
| Errors in formulas are often the
result of typing mistakes, calculations of
invalid data, the wrong formatting, or reference
to an invalid cell. You can correct an error by
editing the cell containing the error. |
| Error |
Meaning |
| ##### |
The
column is too narrow to display
the result of the calculation. To
fix change the width of the
column |
#DIV/0!
|
Divides a
number by zero. In Excel this is
invalid. NOTE: A blank cell is
considered zero. |
#NAME?
|
The
formula contains a function name
or cell reference Excel does not
recognize. |
#VALUE!
|
The
formula refers to a cell that
Excel cannot use in a calculation. |
#REF!
|
The
formula refers to a cell that is
invalid. |
|
| |
|
|
|
|
