View Single Post
  #1   Report Post  
Niall
 
Posts: n/a
Default 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