Rounding
 

Can't I round the result of a calculation, with the result
in one cell? For example,

=ROUND((A1+B1)/5)

Any help appreciated!

Reg

Don't forget the 2nd argument of ROUND.

=ROUND(---,n)

where n is a number representing the number of decimal
places that the number should be rounded to. For example,

=ROUND((A1+B1)/5,1)

HTH
Jason
Atlanta, GA

-----Original Message-----
Can't I round the result of a calculation, with the
result
in one cell? For example,

=ROUND((A1+B1)/5)

Any help appreciated!

Reg
.

Hi,

Yes but you have to tell Excell what you want it rounded too.

=ROUND((A1+B1)/5,0)

This will round to the whole number.

HTH
cwilson

"Reggie" wrote:

Can't I round the result of a calculation, with the result
in one cell? For example,

=ROUND((A1+B1)/5)

Any help appreciated!

Reg

Thank you very much! Both to you and Mr. Morin!
Reg
-----Original Message-----
Hi,

Yes but you have to tell Excell what you want it rounded
too.

=ROUND((A1+B1)/5,0)

This will round to the whole number.

HTH
cwilson

"Reggie" wrote:

Can't I round the result of a calculation, with the
result
in one cell? For example,

=ROUND((A1+B1)/5)

Any help appreciated!

Reg

.