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

 

[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.

 

[Graham Mayor]

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

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

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>