Rounding Up

 DevX Home Today's Headlines   Articles Archive   Tip Bank   Forums

# Thread: Rounding Up

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

 FAQ Latest Articles Java .NET XML Database Enterprise
 Questions? Contact us. C++ Web Development Wireless Latest Tips Open Source