Rounding up in Mergefields

[SSwan]

Hello.

Sheets is a mergefield of any positive value. I need to divide this value by
25 each time but need it to round the result up everytime to a whole number.

e.g. if sheets = 5, I need the result to be 1
e.g. if sheets = 26, I need the result to be 2 etc.

This is my code thus far:

{ =({MERGEFIELD sheets}/25 \# 0}

Any help would be appreciated. Thanks.

 

[macropod]

Hi,

Word doesn't have a roundup/down function, but you can simulate one with a
bit of field maths:
{=ROUND(({MERGEFIELD sheets}/25+(MOD({MERGEFIELD
sheets},25)<>0)/2/25),0)*25}

See my Word Field Maths 'tutorial' at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442
for more details.

Cheers

 

[SSwan]

Thanks, I tried that but with a test input of 2, 5, 25, 26, 50, 54, 75, 845 I
got answers of 0, 0, 25, 25, 50, 50, 75, 850 instead of 1, 1, 1, 2, 2, 3, 3,
34???

Doesn't WOPR send Woodys watch etc? I get that.

....

 

[Greg]

SSwan,

Macropod will most likely be back to sort you out with his method. In
the meantime this appears to work:

{=INT({TEST}/25 + { IF { =MOD({ Test},25)} > "0""1""0" }) }

 

[SSwan]

Thank you very much Greg. It works a treat.

Kindest regards.