merge fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mandy Hudgins - 13 May 2004 14:56 GMT

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

Reply to this Message

Peter Jamieson - 13 May 2004 15:40 GMT

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.

Signature

Peter Jamieson

> I am trying to perform a calculation on a field that I am
> merging in. Example:
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message

Graham Mayor - 13 May 2004 17:42 GMT

> I am trying to perform a calculation on a field that I am
> merging in. Example:
[quoted text clipped - 5 lines]
>
> 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

Signature

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

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

Reply to this Message