number rounding

can i set rounding conditionally? up from .5, down if below?

Use the ROUND() function:

=ROUND(A1,0)

will yield 1 if A1 contains 1.1
will yield 2 if A1 contains 1.9
--
Gary's Student


"tamiluchi" wrote:

> can i set rounding conditionally? up from .5, down if below?

I'm doing this for a whole column. Each cell in this column contains an
average for the sum of 2 rows. I want to round the average up if .5 or
greater, down if less than .5. I can't make it work. I have ROUND(.5,1), but
it rounds all the decimals up, even those less than .5

"Gary''s Student" wrote:

> Use the ROUND() function:
>
> =ROUND(A1,0)
>
> will yield 1 if A1 contains 1.1
> will yield 2 if A1 contains 1.9
> --
> Gary's Student
>
>
> "tamiluchi" wrote:
>
> > can i set rounding conditionally? up from .5, down if below?

Use

=ROUND(A2,0)

assuming A2 has the average formula.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"tamiluchi" <[email protected]> wrote in message
news:[email protected]...
> I'm doing this for a whole column. Each cell in this column contains an
> average for the sum of 2 rows. I want to round the average up if .5 or
> greater, down if less than .5. I can't make it work. I have ROUND(.5,1),
but
> it rounds all the decimals up, even those less than .5
>
> "Gary''s Student" wrote:
>
> > Use the ROUND() function:
> >
> > =ROUND(A1,0)
> >
> > will yield 1 if A1 contains 1.1
> > will yield 2 if A1 contains 1.9
> > --
> > Gary's Student
> >
> >
> > "tamiluchi" wrote:
> >
> > > can i set rounding conditionally? up from .5, down if below?

that seems to work. thank you so very much!!

"Bob Phillips" wrote:

> Use
>
> =ROUND(A2,0)
>
> assuming A2 has the average formula.
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "tamiluchi" <[email protected]> wrote in message
> news:[email protected]...
> > I'm doing this for a whole column. Each cell in this column contains an
> > average for the sum of 2 rows. I want to round the average up if .5 or
> > greater, down if less than .5. I can't make it work. I have ROUND(.5,1),
> but
> > it rounds all the decimals up, even those less than .5
> >
> > "Gary''s Student" wrote:
> >
> > > Use the ROUND() function:
> > >
> > > =ROUND(A1,0)
> > >
> > > will yield 1 if A1 contains 1.1
> > > will yield 2 if A1 contains 1.9
> > > --
> > > Gary's Student
> > >
> > >
> > > "tamiluchi" wrote:
> > >
> > > > can i set rounding conditionally? up from .5, down if below?
>
>
>

Oh, darn! That works wonderfully except that it rounds up greater than .5 ...
I need it to round up at .5

"tamiluchi" wrote:

> that seems to work. thank you so very much!!
>
> "Bob Phillips" wrote:
>
> > Use
> >
> > =ROUND(A2,0)
> >
> > assuming A2 has the average formula.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "tamiluchi" <[email protected]> wrote in message
> > news:[email protected]...
> > > I'm doing this for a whole column. Each cell in this column contains an
> > > average for the sum of 2 rows. I want to round the average up if .5 or
> > > greater, down if less than .5. I can't make it work. I have ROUND(.5,1),
> > but
> > > it rounds all the decimals up, even those less than .5
> > >
> > > "Gary''s Student" wrote:
> > >
> > > > Use the ROUND() function:
> > > >
> > > > =ROUND(A1,0)
> > > >
> > > > will yield 1 if A1 contains 1.1
> > > > will yield 2 if A1 contains 1.9
> > > > --
> > > > Gary's Student
> > > >
> > > >
> > > > "tamiluchi" wrote:
> > > >
> > > > > can i set rounding conditionally? up from .5, down if below?
> >
> >
> >

No it rounds .5 up. Your value is probably less than .5 but formatted to 1
decimal place so it looks like .5

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"tamiluchi" <[email protected]> wrote in message
news:[email protected]...
> Oh, darn! That works wonderfully except that it rounds up greater than .5
....
> I need it to round up at .5
>
> "tamiluchi" wrote:
>
> > that seems to work. thank you so very much!!
> >
> > "Bob Phillips" wrote:
> >
> > > Use
> > >
> > > =ROUND(A2,0)
> > >
> > > assuming A2 has the average formula.
> > >
> > > --
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > (remove nothere from email address if mailing direct)
> > >
> > > "tamiluchi" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > I'm doing this for a whole column. Each cell in this column contains
an
> > > > average for the sum of 2 rows. I want to round the average up if .5
or
> > > > greater, down if less than .5. I can't make it work. I have
ROUND(.5,1),
> > > but
> > > > it rounds all the decimals up, even those less than .5
> > > >
> > > > "Gary''s Student" wrote:
> > > >
> > > > > Use the ROUND() function:
> > > > >
> > > > > =ROUND(A1,0)
> > > > >
> > > > > will yield 1 if A1 contains 1.1
> > > > > will yield 2 if A1 contains 1.9
> > > > > --
> > > > > Gary's Student
> > > > >
> > > > >
> > > > > "tamiluchi" wrote:
> > > > >
> > > > > > can i set rounding conditionally? up from .5, down if below?
> > >
> > >
> > >

You are so right! Thank you very much... again!

"Bob Phillips" wrote:

> No it rounds .5 up. Your value is probably less than .5 but formatted to 1
> decimal place so it looks like .5
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "tamiluchi" <[email protected]> wrote in message
> news:[email protected]...
> > Oh, darn! That works wonderfully except that it rounds up greater than .5
> ....
> > I need it to round up at .5
> >
> > "tamiluchi" wrote:
> >
> > > that seems to work. thank you so very much!!
> > >
> > > "Bob Phillips" wrote:
> > >
> > > > Use
> > > >
> > > > =ROUND(A2,0)
> > > >
> > > > assuming A2 has the average formula.
> > > >
> > > > --
> > > > HTH
> > > >
> > > > Bob Phillips
> > > >
> > > > (remove nothere from email address if mailing direct)
> > > >
> > > > "tamiluchi" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > I'm doing this for a whole column. Each cell in this column contains
> an
> > > > > average for the sum of 2 rows. I want to round the average up if .5
> or
> > > > > greater, down if less than .5. I can't make it work. I have
> ROUND(.5,1),
> > > > but
> > > > > it rounds all the decimals up, even those less than .5
> > > > >
> > > > > "Gary''s Student" wrote:
> > > > >
> > > > > > Use the ROUND() function:
> > > > > >
> > > > > > =ROUND(A1,0)
> > > > > >
> > > > > > will yield 1 if A1 contains 1.1
> > > > > > will yield 2 if A1 contains 1.9
> > > > > > --
> > > > > > Gary's Student
> > > > > >
> > > > > >
> > > > > > "tamiluchi" wrote:
> > > > > >
> > > > > > > can i set rounding conditionally? up from .5, down if below?
> > > >
> > > >
> > > >
>
>
>

On Thu, 20 Apr 2006 08:20:02 -0700, tamiluchi
<[email protected]> wrote:

>can i set rounding conditionally? up from .5, down if below?

=ROUND(A1,0)


--ron