Mail Merge Math - Syntax Error

[MerissaGargiulo]

Hello. I'm trying to perform the following calculation on merge field
in Word 2003
{ =(({ MERGEFIELD "BuyerLotPrice" }-{ MERGEFIELD "BuyerLotIncentive
})+({ MERGEFIELD "BuyerBaseHousePrice" }-{ MERGEFIEL
"BuyerBaseHouseIncentive" }))

My goal is this in normal math terms
(BuyerLotPrice-BuyerLotIncentive)
(BuyerBaseHousePrice-BuyerBaseHouseIncentive

I keep getting "Syntax Error". The document recognizes the amounts o
each field individually, it just isn't performing the math

Assuming I typed everything correctly above since it wouldn't paste, ca
anyone tell me what I'm doing wrong? This is my first attempt at mai
merge math, though I'm familiar with Excel math and somewhat familia
with database fields. I've tried different google searches to solve thi
on my own, and I just cannot find a good resource for syntax help fo
this subject. Thank you

 

[Lisa Wilke-Thissen]

Hi,

[Word 2003]

{ =(({ MERGEFIELD "BuyerLotPrice" }-
{ MERGEFIELD "BuyerLotIncentive"})+
({ MERGEFIELD "BuyerBaseHousePrice" }-
{ MERGEFIELD "BuyerBaseHouseIncentive" }))}

It should be:

{ = { Mergefield A } -
{ Mergefield B } +
{ Mergefield A } -
{ Mergefield A } }

Ctrl + F9 will insert an empty pair of brackets. After typing "=" you
can insert the Mailmerge fields by using the Mail Merge toolbar (or
other ways you usually use).
You have to type manually just the operators "+" and "-".
Switch between Word field codes and field results by pressing Alt + F9.

 

[Lisa Wilke-Thissen]

Sorry,

Of course it should be:

{ = { Mergefield A } -
{ Mergefield B } +
{ Mergefield C } -
{ Mergefield D } }

You mentioned 4 different Mailmerge fields.

 

[rbp2]

MerissaGargiulo wrote on 09/07/2012 14:08 ET

Hello. I'm trying to perform the following calculation on merge fiel
in Word 200
{ =(({ MERGEFIELD "BuyerLotPrice" }-{ MERGEFIEL
"BuyerLotIncentiv
})+({ MERGEFIELD "BuyerBaseHousePrice" }-{ MERGEFIE
"BuyerBaseHouseIncentive" })

My goal is this in normal math term
(BuyerLotPrice-BuyerLotIncentive
(BuyerBaseHousePrice-BuyerBaseHouseIncentiv

I keep getting "Syntax Error". The document recognizes the amounts
each field individually, it just isn't performing the mat

Assuming I typed everything correctly above since it wouldn't paste, c
anyone tell me what I'm doing wrong? This is my first attempt at ma
merge math, though I'm familiar with Excel math and somewhat famili
with database fields. I've tried different google searches to solve th
on my own, and I just cannot find a good resource for syntax help f
this subject. Thank yo


MerissaGargiul

i'm having a similar problem with even a less complex equation, simply tw
fields
{={mergefield 1}+{mergefield 2}} ... result is !Syntax Error,

 

[Lisa Wilke-Thissen]

Hi,

i'm having a similar problem with even
a less complex equation, simply two fields.
{={mergefield 1}+{mergefield 2}} ... result is !Syntax Error,

what version of Word, what language is used? How did you create the fields?

 

[annmarie.t.edward]

Hello,

I am having the same problem, except I am subtracting numbers. I get a Syntax error when i substract a negative number... help!
{={mergefield 1}-{mergefield 2}}
where mergefield2 < 0

Hi,

i'm having a similar problem with even

a less complex equation, simply two fields.

{={mergefield 1}+{mergefield 2}} ... result is !Syntax Error,

what version of Word, what language is used? How did you create the fields?



--

Cheers,

Lisa [MS MVP Word]

 

[Lisa Wilke-Thissen]

Hi,

I am having the same problem, except I am
subtracting numbers.
I get a Syntax error when i substract a negative
number... help!
{={mergefield 1}-{mergefield 2}}
where mergefield2 < 0

did you read my questions? Please answer them, otherwise it is difficult to
find the solution.