ROUND Function in a formula

[Lorenzo]

Hello,
I am trying to round up/down a number in a document. I am struggling with
the syntax and I keep getting an error.
This is what I am trying to do, I am currently using a table but I guess I
can accomplish the same result also with bookmarks.

I have totalPrice, Deposit (which is the totalPrice - 30%) and the balance
that is abviously the totalPrice-Deposit
I want to round up nearest to 5 the Deposit so in the calculated field I
would have:

=ROUND((totalPrice*100/130),5)

I can't get it to work even if for testing porpouses I put

=ROUND(1327,5)

can you help me on the syntax of the ROUND function in a Formula.

Thanks,
Lorenzo

 

[Tony Jollans]

I'm afraid ROUND doesn't work like that - it only rounds after the point to
a number of decimal places.

To round up to the nearest 5 takes a bit of messing about. Try this ..

=ROUND(1327/5 + 0.49,0)*5

--
Ø[}
"Lorenzo"
<CuTT-!thISoFfonlyLeAveMyNamelorenzoWithNoNuMBErS98776@LeaveMyCountry!!!ITAL
IANlodging.it.NOSPAM> wrote in message
news:[email protected]...

 

[macropod]

Hi Lorenzo,

To see how to do this and a wide range of other calculations in Word, check
out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442

Cheers


"Lorenzo"
<CuTT-!thISoFfonlyLeAveMyNamelorenzoWithNoNuMBErS98776@LeaveMyCountry!!!ITAL
IANlodging.it.NOSPAM> wrote in message
news:[email protected]...