Error at <Cell Reference> Appears Instead of Result

ID: Q115259

The information in this article applies to:

Microsoft Word for Windows, versions 6.0, 6.0a, 6.0c
Microsoft Word for Windows 95, version 7.0

SYMPTOMS

If a formula in a table refers to a cell that is blank, the formula shows the following error message instead of a result:

!Error at <cell reference>

If there are nested formulas, the field will show a previous result or will not show any result.

For example, the formula in B1 of the table below refers to A1. When A1 contains a number, B1 will show the result of A1 multiplied by 6. When A1 is empty, B1 will show "!Error at A1".


     --------------------
   |         | {=A1*6}  |
    --------------------

CAUSE

Word 97 evaluates a blank cell as a zero. Word 95 and earlier do not evaluate formulas for which any of the elements are unknown.

WORKAROUND

Type a 0 (zero) in the blank cell. If you do not want the 0 to display, format it as Hidden.

NOTE: {IF} fields and bookmarks are not effective in this situation.

Additional query words:

Keywords : kbfield kbtable
Version : WINDOWS:6.0,6.0a,6.0c,7.0
Platform : WINDOWS
Issue type :