Thread: Rounding to the nearest 5
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lisa Lisa is offline
external usenet poster
  
Posts: 328
Default Rounding to the nearest 5
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?
Reply With QuoteReply With Quote