Quote:
Originally Posted by 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}
|
Hey there,
I have a similar problem. I have mergefield with expression:
{ =PRODUCT(Price;0,85)} the result is for example is 132,859
and I need it to be rounded down to 2 decimal places as well, so 132,85.
I tried your function but it doesnt work for me.