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

Once again, what you have posted is nothing like what Graham had suggested.

You posted:

{ IF { MERGEFIELD CoverageLevel } = "" "" { = { ( {MERGEFIELD
CoverageLevel} / 5000) \# "$,0.00" } 0}

It should be:

{ IF { MERGEFIELD CoverageLevel } = "" "" { = ( {MERGEFIELD
CoverageLevel} / 5000) \# "$,0.00" }

But, what does { MERGEFIELD CoverageLevel } if it is not empty.
--
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
ups.com...
One additional note, i was able to get the formula from Graham's reply:

{ IF { MERGEFIELD CoverageLevel } = "" "" { = { ( {MERGEFIELD
CoverageLevel} / 5000) \# "$,0.00" } 0}

to update without getting a Syntax Error, but it Always evaluates to 0
no matter what the CoverageLevel is ( i have that displayed in another
field so i know it's nonzero). I imagine it's because of the 0
appended to the end, but i don't know what that 0 is supposed to
signify.

Thanks in advance,

Daryl