If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I force two merge fields to calculation in word 2000
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 |
#2
|
|||
|
|||
How can I force two merge fields to calculation in word 2000
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. -- 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. "Jane Humbrey" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|