Rounding Up


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Rounding Up

  1. #1
    neilw Guest

    Rounding Up


    Hi there

    I have a number of days if divided by 7 gives me the amount of weeks

    If i get 3.1 i need to make the number rounded up to 4
    Is there any easy way of doing this.??

    TIA
    Neil


  2. #2
    Cindy Winegarden Guest

    Re: Rounding Up

    Neil,

    Look at the ROUND() function.

    --

    Cindy Winegarden MCSD, MVP
    cindy.winegarden@mvps.org


    "neilw" <neilw@tpgplc.co.uk> wrote in message
    news:3b40a1a5$1@news.devx.com...
    >
    > Hi there
    >
    > I have a number of days if divided by 7 gives me the amount of weeks
    >
    > If i get 3.1 i need to make the number rounded up to 4
    > Is there any easy way of doing this.??
    >
    > TIA
    > Neil
    >



  3. #3
    Robert Hoogstraat Guest

    Re: Rounding Up

    Perhaps the CEILING() function in this case?


    --
    Robert Hoogstraat [SI]


    "Cindy Winegarden" <cindy.winegarden@mvps.org> wrote in message
    news:3b40aa12$1@news.devx.com...
    > Neil,
    >
    > Look at the ROUND() function.
    >
    > --
    >
    > Cindy Winegarden MCSD, MVP
    > cindy.winegarden@mvps.org
    >
    >
    > "neilw" <neilw@tpgplc.co.uk> wrote in message
    > news:3b40a1a5$1@news.devx.com...
    > >
    > > Hi there
    > >
    > > I have a number of days if divided by 7 gives me the amount of weeks
    > >
    > > If i get 3.1 i need to make the number rounded up to 4
    > > Is there any easy way of doing this.??
    > >
    > > TIA
    > > Neil
    > >

    >




  4. #4
    Cindy Winegarden Guest

    Re: Rounding Up

    Thanks Robert. I didn't see the .1 he wanted to round to the next whole
    number.

    --

    Cindy Winegarden MCSD, MVP
    cindy.winegarden@mvps.org


    "Robert Hoogstraat" <roberth@software-intellect.com> wrote in message
    news:3b40f546@news.devx.com...
    > Perhaps the CEILING() function in this case?
    >
    >
    > --
    > Robert Hoogstraat [SI]
    >
    >
    > "Cindy Winegarden" <cindy.winegarden@mvps.org> wrote in message
    > news:3b40aa12$1@news.devx.com...
    > > Neil,
    > >
    > > Look at the ROUND() function.
    > >
    > > --
    > >
    > > Cindy Winegarden MCSD, MVP
    > > cindy.winegarden@mvps.org
    > >
    > >
    > > "neilw" <neilw@tpgplc.co.uk> wrote in message
    > > news:3b40a1a5$1@news.devx.com...
    > > >
    > > > Hi there
    > > >
    > > > I have a number of days if divided by 7 gives me the amount of weeks
    > > >
    > > > If i get 3.1 i need to make the number rounded up to 4
    > > > Is there any easy way of doing this.??
    > > >
    > > > TIA
    > > > Neil
    > > >

    > >

    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center