# Rounding Up

Printable View

• 07-02-2001, 12:30 PM
neilw
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

• 07-02-2001, 01:13 PM
Cindy Winegarden
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
>

• 07-02-2001, 06:35 PM
Robert Hoogstraat
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
> >

>

• 07-02-2001, 09:06 PM
Cindy Winegarden
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
> > >

> >

>
>