How can we force two merge fields for calculation in Word 2000?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jane Humbrey - 29 Apr 2004 23:54 GMT

Hi Friends

I use Word 2000.How can I force two merge fields to calculation?. If I have
MERGEFIELD A and MERGEFIELD B and these take values from an excel data
source like the following :

A B
---- -----
$10 $20
$50 $25
$40 $30
--- -----
--- -----

I want to get the addition of MERGEFIELD A and MERGEFIELD B in the word
merge file while I do the merge to the above excel data source. ie. I want
to get the results ($30,$75 and $70 respectively rather than to print
$10+$20,$50+$25,.......)

Can you tell me the exact method/formula please?

Jane

Reply to this Message

Doug Robbins - Word MVP - 30 Apr 2004 03:43 GMT

Use the following field construction

{ = { MERGEFIELD "A" } + { MERGEFIELD "B" } }

You must use Ctrl+F9 to insert each pair of field delimiters { }

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> Hi Friends
>
[quoted text clipped - 18 lines]
>
> Jane

Reply to this Message