number rounding

[tamiluchi]

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

 

[Gary''s Student]

Use the ROUND() function:

=ROUND(A1,0)

will yield 1 if A1 contains 1.1
will yield 2 if A1 contains 1.9

 

[tamiluchi]

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

 

[Bob Phillips]

Use

=ROUND(A2,0)

assuming A2 has the average formula.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[tamiluchi]

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

Use

=ROUND(A2,0)

assuming A2 has the average formula.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[tamiluchi]

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

 

[Bob Phillips]

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]

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

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)

 

[Ron Rosenfeld]

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

=ROUND(A1,0)


--ron