View Single Post
  #13   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default Calculations in a mergefield.

Let's take a step back and start this again
You want to divide the number produced by the coveragelevel field by 5000 if
the coverage level field contains a number, or if it is empty enter a 0?

Then what you need is:

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


wrote:
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