Thanks. I blew that one, completely. Tried to get back to it when I saw they
wanted to round DOWN on .5, and got tied up. Thanks. :)
"JE McGimpsey" wrote in message
...
That will give a syntax error, since you didn't include the second
argument.

Note that even =ROUND(A1,0) will give the wrong answer for the OP's
requirements. =ROUND(1.5,0) = 2, not 1.



In article ,
"Anne Troy" wrote:

=round(a1)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"aries0070"
wrote
in message
...

I want to round of number for example:

1.5 = 1
1.6 = 2

What function should I use. Please help me. Thanks


--
aries0070

------------------------------------------------------------------------
aries0070's Profile:
http://www.excelforum.com/member.php...o&userid=25077
View this thread:
http://www.excelforum.com/showthread...hreadid=386182