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 <[email protected]>,
"Anne Troy" <[email protected]> wrote:

> =round(a1)
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> "aries0070" <[email protected]> wrote
> in message news:[email protected]...
> >
> > 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
> >