round question


Posted by Andonny on June 10, 2001 4:52 PM

Hi,
I need to round the result of this formula but I am not sure why it doesn't work.
'=SUM(ROUND(A2+B2,1)/3,1)

Thanks
Andonny

Posted by Mark W. on June 10, 2001 5:42 PM

What's in cells A2:B2? What results are you expecting?

Posted by Andonny on June 10, 2001 6:46 PM

Hi Mark,
I would like to add up A2 to B2 and divide the lot by 3 and then get a rounded result. Below 0.5 round down and above round up.

Thanks a lot
Andonny



Posted by Mark W. on June 10, 2001 7:28 PM

=ROUND((A2+B2)/3,1)