Posted to microsoft.public.excel.worksheet.functions
|
|
How can I always ROUND UP to the nearest multipal of 5 in excl
=ceiling(a1,5)
Hth
--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=556265
|