View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default Rounding up on a merged field

Word should produce 2348.12 without interference if you use a switch eg \#
",0.00" but if for some reason I cannot fathom it is not doing so then you
could force the same effect with calculated fields eg

{IF { Mergefield Total \# ".000" } = ".??5" "{ =({ Mergefield Total \#
",0.00" } + .01) \# ",0.00" }" "{Mergefield Total \# ",0.00" }" }

would produce the result you require.

--

Graham Mayor - Word MVP

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



wmannod wrote:
Hi I have the decimal places down with {mergefield total \#,##0.00}
But my amount to the third decimal place is 2,348.115. How do I get
the 5 to round up. I'm looking for 2348.12 it always rounds down at
5. And give me a total of 2348.11.

thanks in advance.