ROUND Function in a formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lorenzo - 10 Jan 2006 17:56 GMT

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

Reply to this Message

Tony Jollans - 10 Jan 2006 20:46 GMT

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:uj1l98gFGHA.752@TK2MSFTNGP12.phx.gbl...

> Hello,
> I am trying to round up/down a number in a document. I am struggling with
[quoted text clipped - 17 lines]
> Thanks,
> Lorenzo

Reply to this Message

macropod - 21 Jan 2006 10:54 GMT

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:uj1l98gFGHA.752@TK2MSFTNGP12.phx.gbl...

> Hello,
> I am trying to round up/down a number in a document. I am struggling with
[quoted text clipped - 17 lines]
> Thanks,
> Lorenzo

Reply to this Message

Rate this thread: