Creating a Formula in Word for a Mergefield 3

[Crystalamateur]

Hi
Is it possible to create a formula for a mergefield in a word document. I need to show 25% of an amount paid for Gift Aid e.g if paid £500 need to show Gift aid claimed will be £125
Thanks

 

[GSCaupling]

We probably need some additional details, Crystalamateur.

What version of Word? What is your data source? Could you do the computation at the source and then import the results?

GS

[red]******^*******
[small]I[/small] [small]Love[/small] [♥] [small]Redundancy.[/small][/red]

 

[macropod]

Hi Crystalamateur,

This is quite straightforward - once you know how.

To create the formula in Word:
. select your mergefield, which will look something like «Gift»;
. press Ctrl-F9 to wrap another field around it, thus - { «Gift» };
. edit the field so that you get {=«Gift»/4 \# "£,0.00"};
. position the cursor anywhere in this field and press F9 to update it;
. run your mailmerge.

Note: the precision of the displayed value is controlled by the '0.00'. You can use anything from '0' to '0.000000000000000'.



Cheers
[MS MVP - Word]

 

[Crystalamateur]

Hi Macropod

It worked! - many thanks

 

[fumei]

When it comes to Fields, macropod is tops. Darn, I know I have a bookmark to his fantastic document on using Fields somewhere.....

Gerry

 

[macropod]

Hi Gerry,

Here you go:

Date Calculations

http://www.wopr.com/index.php?showtopic=249902

Word Field Maths

http://www.wopr.com/index.php?showtopic=365442

Catalogue/Directory Mailmerges

http://www.wopr.com/index.php?showtopic=731107

Relative Paths for Document links

http://www.wopr.com/index.php?showtopic=670027

Cheers
[MS MVP - Word]

 

[cmeagan656]

Awesome! Thanks for the links macropod.

Hope this helps.

Please help us help you. Read Tek-Tips posting polices before posting.

 

[Crystalamateur]

Hi Macropod

Many thanks for the links

 

[fumei]

Thanks for posting...again. I will archive this one (although I thought I already had).

Everyone else, these are indeed the best documentation of Word fields anywhere.

Gerry