I have a cell that has a whole number.I want round it to the nearest
muliple of 5.
Examples:
231 round down to 230
232 round down to 230
233 round up to 235
234 round up to 235
235 = 235
236 round down to 235
237 round down to 235
238 round up to 240
239 round up to 240
240 =240
and so on
Is there a formula to do this. Ceiling and Floor does not work.
Thanks for any help
Joe
--
JoeBed
------------------------------------------------------------------------
JoeBed's Profile:
http://www.excelforum.com/member.php...o&userid=21368
View this thread:
http://www.excelforum.com/showthread...hreadid=384539