Colin,

Try,

=IF(A1<5,0,IF(AND(A15,A1<50),CEILING(A1,5),CEILIN G(A1,10)))

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=545079