Function for Rounding of Number

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
> >

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" <[email protected]> wrote in message
news:[email protected]...
> 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
> > >

Thanks to all. I got it.