Error at <Cell Reference> Appears Instead of Result (115259)

The information in this article applies to:

Microsoft Word for Windows 6.0
Microsoft Word for Windows 6.0a
Microsoft Word for Windows 6.0c
Microsoft Word for Windows 95

This article was previously published under Q115259

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.

Modification Type:	Minor	Last Reviewed:	8/16/2005
Keywords:	kbfield kbtable KB115259