Ron's formula will work unless C18 is 0, so you may need to add an if
statement.

=IF(C18=0,2.5,CEILING(C18/5,1)*2.5)

If 0 should return 0 then just use Ron's formula.


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=510544