Thread
:
Calculations in a mergefield.
View Single Post
#
13
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
Posts: n/a
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
Reply With Quote