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