You don't really want 3.5 to become 4 do you?

perhaps, if you only have positive numbers

=CEILING(A1,0.5)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=525473