Rounding

[Reggie]

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

 

[Jason Morin]

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

 

[cwilson]

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]

Thank you very much! Both to you and Mr. Morin!
Reg