merge fields

[Mandy Hudgins]

I am trying to perform a calculation on a field that I am
merging in. Example:

I am merging in the student balance: 7,000

The next field I want to take the student balance and
multiply times .40 and add 30.00. How do I do this?

Thanks

[Graham Mayor]

Post by Mandy Hudgins
I am trying to perform a calculation on a field that I am
I am merging in the student balance: 7,000
The next field I want to take the student balance and
multiply times .40 and add 30.00. How do I do this?
Thanks

Use a formula field - assuming your field is called Balance - then

{=({Mergefield Balance} * .4 + 30) \# "$,0.00"}

which will display $2,830.00 from 7000

[Peter Jamieson]

As long as the "7,000" is actually a number (i.e. does not actually contain
the comma, which would mean Word would see it as a text string) then you
should be able to insert a nested = field, e.g.

{ =({ MERGEFIELD "student balance" }*0.40)+30 }

Use ctrl-F9 to get each pair of {} and type everything else in the usual
way.
--
Peter Jamieson

Post by Mandy Hudgins
I am trying to perform a calculation on a field that I am
I am merging in the student balance: 7,000
The next field I want to take the student balance and
multiply times .40 and add 30.00. How do I do this?
Thanks