thanks.

-----Original Message-----
Hi
one way:
=ROUND(A1*2,0)/2
or
MROUND(A1,0.5)
for the MROUND function you need the Analysis Toolpak
installed

HTH
Frank

wrote:
Is there a way to round a number to the nearest .5 -
ie .5, 1.0, 1.5, 2.0, 2.5, 3.0, 3.5 etc

TIA


.