Round Down Merge field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Niall - 11 Feb 2005 12:07 GMT

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 to this Message

Greg - 11 Feb 2005 13:11 GMT

Niall,

Word has no specific RoundUp or RoundDown feature, only round. .5 and
higher is rounded up values < .5 are rounded down. You have to use a
constant to force a rounddown or up. In your case you need to subtract
.005 from your
earlier calculation e.g.,
{=round({={MFAR}/4-.005},2}

Reply to this Message