View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 171
Default Rounding to the nearest 5

The formula's okay, but the verbiage isn't... the function is mround (sorry!)

"bpeltzer" wrote:

rmound should do it (eg =mround(63,5) )

"Lisa" wrote:

I need to round a group of numbers to the nearest 5...like 63 would be 65, 68
would be 70, 51 would be 50, etc. Is there a formula for this?