View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Round to nearest multiple

Did you look up MROUND in Excel help?
--
David Biddulph

"James M" wrote in message
...
Hi, I want to round to the nearest (up/down) mutiple of 25. I saw some
info
online about MROUND formulas but I can't seem to get it to work on my 2003
excel and it is not listed as a valid formula within the selection.

I also saw posts about ceilings and floors but I wanted a formula that
would
round both up and down to the approprate multiple.

James