Thread: Rounding to 5.0 or 0.0
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
paul paul is offline
external usenet poster
  
Posts: 247
Default Rounding to 5.0 or 0.0
another way
=MROUND(E7+2.5,5)
--
paul

remove nospam for email addy!



"mgtyper" wrote:


How would I Round up to 5 as in
10.1 to 15
9.9 to 10
105.3 to 110
123.6 to 125


--
mgtyper
------------------------------------------------------------------------
mgtyper's Profile: http://www.excelforum.com/member.php...o&userid=37402
View this thread: http://www.excelforum.com/showthread...hreadid=570891


Reply With QuoteReply With Quote