Thread: Round up to next .5
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default Round up to next .5
LKP wrote:
I am trying to find a formula that will round a number up to the next .5. I
have tried MROUND which gets it to a number that ends in .5, but doesn't
round it up. Does anyone know how to do this?

=CEILING(A1,0.5)
Reply With QuoteReply With Quote