Niall

Posts: n/a

Round Down Merge field

Hi

I have got the following field in a mail merge document:

{={MERGEFIELD Annual_Rent}/4}

I am trying to round down the result to 2 decimal places and tried:

{=ROUNDDOWN({MERGEFIELD Annual_Rent}/4,2)}

but just get a syntax error. Can anyone help? Thanks

Reply With Quote

Thread Tools
Show Printable Version
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Field in Merge Document	Karen Hart	Mailmerge	35	March 29th 05 12:38 PM
Merge field in table of contents	Richard Eggleton	Mailmerge	0	February 2nd 05 12:12 AM
13 numbers added to Word/Excel mail merge field	Pat	Mailmerge	1	January 19th 05 02:10 AM
Home Phone field not getting picked up in Merge	Cathleen McGuire	Mailmerge	4	January 7th 05 03:13 AM
suppress invalid merge field word 2003	Mike	Mailmerge	3	December 9th 04 11:13 AM

All times are GMT +1. The time now is 11:07 PM.

About Us

"It's about Microsoft Word"

Menu

About Us