So does that apply to other numbers, what happens to 3.3 or 5.4?

Perhaps try

=ROUND(A1+0.25,0)


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