Word Formula syntax

Factual Questions
1

I’m using Word 2002, and the following formula results in a syntax error. Can anyone help?

{=SUM { MERGEFIELD “payment” },{={ MERGEFIELD “payment” } * .04} }

2

I think you have to toggle the MERGEFIELD to display field results not just the field codes. SHIFT+F9 in the field does this I think. I don’t think it is getting the numbers.

3

I’m no Word expert, but I don’t see how Mergefield is going to return a number that you can calculate with; it returns the field name. Also see that you’re trying to call up the number entered as “payment” and increase it by 4%; the easier way to do this is to multiply by 1.04, rather than by using two arguments, as you have done. I don’t know how to call up numbers from a data document, though.

4

I quickly recreated what you are trying to do and my formula, which works, looks like this -->

{=SUM({MERGEFIELD “payment”}, ({MERGEFIELD “payment”} * .04)) }

Basically you have too many {}, it’s {=SUM(1+(1*.04))}

Also make sure you create your {} with ctrl+f9

5

Hey, thanks. It worked.