Round Down Merge field

[Niall]

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

 

[Greg]

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}