Thread: How do I round to the nearest 5?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike
 
Posts: n/a
Default How do I round to the nearest 5?
=ROUND(A1/5,0)*5
or
=MROUND(A1,5)

--
Mike

"JoeBed" wrote in message ...
Reply With QuoteReply With Quote