WD: "!Syntax Error, [" in Table FormulaLast reviewed: February 5, 1998Article ID: Q120868 |
The information in this article applies to:
SYMPTOMSThe error message "!Syntax Error, [" appears in a table when a formula field includes certain formula functions and refers to table cells with A1 notation.
CAUSEFunction references to table cells are not in row/column notation.
RESOLUTIONTo resolve this problem, upgrade to the latest version of Microsoft Word. To work around this problem, use either of the following methods.
Method 1Use row/column notation. In this notation, each cell is identified by the letter R and the row number, and the letter C and the column number. For example, cell A1 is called R1C1. Cell B2 is R2C2, cell D15 is R15C4, and so on. For example, you would change this formula
{ =abs(B4) }to this:
{ =abs(R4C2) } Method 2
Apply a bookmark to the contents of the cell you want and refer toit rather than using the cell reference. NOTE: you must include only the contents of the cell when you apply the bookmark. If you highlight the entire cell, you get unpredictable results in the formula result.
STATUSThis problem was corrected in Word 97 and Word 98 Macintosh Edition.
MORE INFORMATIONThe following functions do not require the use of row/column notation (A1 notation can be used):
average count max min product sumThe following functions require the use of row/column notation:
abs and int mod not or round sign |
Additional query words: 6formula equation table cell reference row column
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |