|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
How can I always ROUND UP to the nearest multipal of 5 in excl
thanks I had tried this but needed to alter in order to make it work thanks
again
"Bearacade" wrote:
=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
|