How can I force two merge fields to calculation in word 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jane Humbrey - 30 Apr 2004 00:17 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

Charles Kenyon - 30 Apr 2004 00:34 GMT

Easiest is to actually do the calculation in Excel. It is built for
calculations while those in Word are a kludge.

Something like the following should work:

{ = { MergeField "ColumnA" } + { MergeField "ColumnB" } }

I haven't tried this but expect it will work. The spaces around the
numerical operators in this field are required.

Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

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

Reply to this Message