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