Thread: Round up numbers to either a half or a whole depending on which side of 0.5 it is
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
  
Posts: 510
Default Round up numbers to either a half or a whole depending on which side of 0.5 it is
Hi


"John Williams" wrote in message
...
Hi

Thanks for the two replies both of you. They both work, but if the sum
does equal say 15.5 then they both round that up to 16 and not leave it at
15.5


=ROUNDUP((A1-0.1)/5,1)*5



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


Reply With QuoteReply With Quote