Syntax Errors in Word 2016

[laurenbseattle]

Hi all -

Have reached my wit's end with this. I am working in Word 2016, per a recent upgrade at work, and using the legacy tools to run calculations in a form.

I am stuck on a IF problem, where if the dropdown field says "Yes" I need Word to run a calculation, and to display $0.00 otherwise. I have been making minor tweaks to the below for hours, and getting various !Syntax Error back (#, *, etc.):

{ IF { ref DropDown } = "Yes" " { = { AVERAGE (Value1, Value2, Value3, Value4) } * { Area } * { RentalRate } * { TaxRate } \ # "$#,##0.00" } " "$0.00" }

WHERE TaxRate is simply a number (e.g. 0.5).

The dropdown field is set to calculate on exit and all {} marks were added using Ctrl+F9.

Value1, Value2, etc. are also calculations of Area1*Subvalue1, which may be contributing.

I have also tried variations on AVERAGE, such as summing the four values and dividing, breaking them up into their own fields, etc. These do not seem to change the problem.

Thanks in advance for your assistance!

Lauren

[dpb]

Post by laurenbseattle
Hi all -
Have reached my wit's end with this. I am working in Word 2016, per a recent upgrade at work, and using the legacy tools to run calculations in a form.

...

I have no solutions but afaict all the tables, etc., formulae in Word
2016 are essentially non-functional and non-fixable.

Like you I spent most of an afternoon trying to simply convert hardcoded
numbers in a proposal table in an inherited document to auto-compute
sums by row and column and never got anything to work either at all or
consistently correctly after an occasional appearance of working initially.

Then trying to embed the same table as Excel wouldn't format...

MS ought to have to try to use their own products. :(

--