Not sure if this is the most efficient of formulas, but i works for
me:-
=IF((A1-INT(A1))<0.25,FLOOR(A1,0.5),IF((A1-INT(A1))=0.75,CEILING(A1,0.5),IF((A1-INT(A1))<0.5,CEILING(A1,0.5),FLOOR(A1,0.5))))
Assuming your value is in A1, if there are to be negative numbers, you
may need to alter the formula to calculate on Absolute values
G
--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile:
http://www.excelforum.com/member.php...o&userid=17084
View this thread:
http://www.excelforum.com/showthread...hreadid=536862