Mergefield Calculation

[Guest]

H

Is there a way to add calculations to a merged field

For instance, I have a value that is merged into a document - { MERGEFIELD "Feb_03_ZMK"#"#,##0 } This field gives me a figure for a loan a client has received. I have another field which requires the same figure to have calculations to be added to it. I know I can add another column to the spreadsheet to achieve this, but I would like to know if there is a way to calculate this straight in word. For instance, Could I have something along the lines o
{ MERGEFIELD "Feb_03_ZMK"#"#,##0 } / 0.05 to give me 5% of the original figure

If there is a way to work out calculations, any help would be greatly appreciated

Thanks in advanc

Malyco

 

[Graham Mayor]

How about

{=({Mergefield "Feb_03_ZMK"} * .05) \# ",0"}

for 5%?


--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>