Hi

Activate Analysis Toolpack Add-In (when you can't, you have to install it
from Office Setup CD). Now you can use ROUNDUP/ROUNDDOWN functions

=ROUNDUP(A1/5,1)*5


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"John Williams" wrote in message
...
Hi

Is there any way in Excel 2002 to do the above.

E.g.

My vertical sum comes to 15.2 so I want that changed to 15.5
or
My vertical sum comes to 15.6 so I want that changed to 16

It doesn't matter if the rounding takes place in a different cell to the
sum.

TIA

John