Roundup or down in a table?

[jrb]

In a Word table I have a calculation =A1/B1 \# "0.00" which works fine, but I have two questions! First I would like to add the round function, and second I would like to add a condition using the MOD function? Is this possible? For the sake of an example here is what I do in Excel that I would like to do in the table.

IF(MOD(I9,1)<0.15,ROUNDDOWN(I9,0),ROUNDUP(I9,0))

I tried to add Roundup(A1/B1,0) but I get a syntax error.

[macropod]

Hi jrb,

Word's formula syntax differs from Excel's. To see how to do rounding up & down, plus a wide range of other calculations in Word, check out my Word Field Maths Tutorial, at:
http://www.wopr.com/index.php?showtopic=365442 (mhtml:{2603C627-B617-484B-B3E3-521BCFB808E8}mid://00001173/!x-usc:http://www.wopr.com/index.php?showtopic=365442)
or
http://www.gmayor.com/downloads.htm#Third_party (mhtml:{2603C627-B617-484B-B3E3-521BCFB808E8}mid://00001173/!x-usc:http://www.gmayor.com/downloads.htm#Third_party)

[jrb]

Thanks Paul this looks great.