View Single Post
  #8   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Calculations in a mergefield.

Use

{ IF { {MERGEFIELD CoverageLevel} "" { = ({MERGEFIELD
CI_AR_CoverageLevel}* 2) \# "##" } 0 }



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

wrote in message
oups.com...
sorry was missing a comma in the above merge field. What i'm seeing
after some tinkering is this. I'll enter a formula, it will evaluate
correctly once, and thereafter when i try and view it it will show up
as Syntax Error!. When i try and update, it says it cannot update
one of the fields on the screen, but i can't for the life of me see why
it won't update it. Here's another look at what i've tried:

The following statement below works. But if i try and embed that in
another CTRL-F9, it says it cannot update it:
{ IF { {MERGEFIELD CoverageLevel} "" "{MERGEFIELD
CI_AR_CoverageLevel}" "0" }

This is the statement with the added formula condition. Word says it
cannot update the field.
{ = { IF { {MERGEFIELD CoverageLevel} "" "{MERGEFIELD
CI_AR_CoverageLevel}" "0" } * 2 }

{ = { IF { {MERGEFIELD CoverageLevel} "" "{MERGEFIELD
CI_AR_CoverageLevel}" "0" } * 2 \# "##" }

I've tried it with and without calculations, i'm stumped. Thanks in
advance for any suggestions. What is it about adding the Formula part
that it fails to update?